Re: Curious SQL question

Guto wrote:
> 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?

I assume you miss one relation here, namely Customer. I think this is what you are looking for:

(Customer x Product) - Orders

/Lennart Received on Wed Jan 03 2007 - 14:26:51 CET