Re: Curious SQL question

"Walt" <wamitty_at_verizon.net> wrote in message news:Vevnh.2$Mf2.1_at_trndny01...
>
> "Guto" <gutomore_at_gmail.com> wrote in message
> news:1167826602.405469.312020_at_48g2000cwx.googlegroups.com...
> > Hi There!
> > If I have two tables:
> >
> > Products
> > -Product_ID
> > -Product_Name
> >
> > and
> >
> > Orders
> > -Customer_ID
> > -Product_ID
> >
> >
> > How can I find out what products, each customer DIDN'T bought?
> >
> > I tried lots of SQL sentences, but I can onlye get it solved, through a
> > Stored Procedure.
> >
> >
> > The obvius does not work:
> >
> > Select Customer_ID, Product_ID from Orders
> > where Product_ID not in ( select Product_id from Products )
> >
> > Any Tips?
> >
> > Regards
> > Carlos Augusto
> >
>
> Carlos,
> You've already got several correct replies, so you don't need this one. I
> just toss it out there as an illustration of MINUS.
>

[erroneous answer snipped.... thanks, Neo]

select distinct

      orders.customer_id,
      products.product_id
 from
     orders,
     products

     customer_id,
     product_id
 from
     orders;