Thread: structured query language (sql)
View Single Post
Old 02-12-2013, 02:23 PM   PM User | #3
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
Quote:
Originally Posted by BubikolRamios View Post
3.

Code:
SELECT p.ProductID
FROM Products p left join Sales s on p.ProductID = s.ProductID
WHERE s.ProductID is null
the customer table is missing from the code section...customer table isnt mentioned anywhere in code?
simon47 is offline   Reply With Quote