-
sql query need help
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|