View Single Post
Old 02-12-2013, 01:46 PM   PM User | #1
simon47
New to the CF scene

 
Join Date: Jan 2013
Posts: 6
Thanks: 1
Thanked 0 Times in 0 Posts
simon47 is an unknown quantity at this point
Question structured query language (sql)

can someone please help me with this sql coding.... the diagram is given below..

List the all products which haven’t been bought by any customer....
(i tried this but i m not sure if this is correct)

SELECT ProductID, CustomerID
FROM Products , Customers
WHERE ProductID NOT IN (SELECT CustomerID);
Attached Thumbnails
Click image for larger version

Name:	sql.jpg
Views:	48
Size:	48.3 KB
ID:	11929  

Last edited by simon47; 02-13-2013 at 04:47 AM..
simon47 is offline   Reply With Quote