unmatching query delete

[kim jackson]

I have 2 tables [Accounts] [EquipID], I have used to
without Matching query on the [cirid] field on each
table.. How do I delete the results of my query from the
my [Accounts] table.
Thanks

 

[[MVP] S. Clark]

To delete records from one table, based on records from another, you can use
an inner join, or specify linking criteria in the where clause.

i.e. DELETE Customers.*, Orders.OrderDate
FROM Customers INNER JOIN Orders ON Customers.CustomerID = Orders.CustomerID
WHERE (((Orders.OrderDate)<#1/1/2000#));

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-