hi,
i am having problem selecting the data i want..

i have 3 tables as follow :

Customer table
---------------------------
customerid customername


Product table
---------------------------
productid productname


Order product (Customer - Product) table
---------------------------
customerid productid


given a customer id, i wan to be able to select all products that the given customer had NOT yet ordered.... is this possible?? hope someone can help me... thz a lot