delete query

[Kurt Neumann]

access 2000, windows xp
i have two tables say, customers and orders with a one to many link of
invoice number
i wish to delete from customers all records with no orders.
i can do a select query with a null criteria in the invoice number in
orders to find all unmatched customers, but when i try to make this into a
delete query, i get a notice that i must select the table and i don't know
how to do that. any help.

ie, i want to delte from table 1 all records with no match in table 2.
thanks
khn

 

[Allen Browne]

Use a subquery in the WHERE clause.

Something like this:
DELETE FROM Customers
WHERE NOT EXISTS
(SELECT OrderID FROM Orders
WHERE Orders.CustomerID = Customers.CustomerID);