delete query

[samotek via AccessMonster.com]

I need to update the table products from the products in the table [order
details] and also delete all the products in the table products that are not
contained in the table [order details]. My update query is sucessful as
follows
UPDATE products1 INNER JOIN [Order Details1] ON products1.Productid = [Order
Details1].productid SET products1.branch9 = [order details1].[cartons];
But how can i delete the products that are not contained in the table order
details?

 

[Allen Browne]

This should do it:

DELETE FROM products1
WHERE NOT EXISTS
(SELECT ProductID
FROM [order details1]
WHERE [order details1].productID = products.productid);

If subqueries are new, see:
http://allenbrowne.com/subquery-01.html