Curious SQL question

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 Received on Wed Jan 03 2007 - 06:16:42 CST