How to delete customers without orders

D

DianePDavies

I have made an "unmatched query" showing all my "customers" without "orders".
Now I want to delete these customers.

How do I make a single query that deletes all my customers without orders?
 
N

Nikos Yannacopoulos

Diane,

Set up a DELETE query on table Customers, and use the following
criterion on the CustomerID field:

Not In (SELECT CustomerID FROM Orders)

where I have assumed table Orders to have a CustomerID field; substitute
the actual tables.

Tip: back up before you try!

HTH,
Nikos
 
Top