The following returns customers that have made no orders:
SELECT customerid FROM dbo.Customers
EXCEPT
SELECT customerid FROM dbo.Orders
Showing posts with label Set Operation. Show all posts
Showing posts with label Set Operation. Show all posts
Wednesday, 11 November 2009
Subscribe to:
Posts (Atom)