SQL query Help

[jonnyk]

I need to find all records from one table that dont have an entry in another table.
Is there a SQL staement that will do this for me?
IE All customers that have no orders

 

[sunila7]

Hi,

Try this query...


SELECT *
FROM Customers
WHERE NOT EXISTS
(SELECT customerid
FROM orders
WHERE customerid = customers.customerid)


Sunil