Delete Query

[jeff_i]

Most likely a simple question:

How do make a query to find unmatched records, then delete the unmatched records. I can find the unmatched records but then using the criteria for the delete query is not working at all. I am just stumped.

Here is what I have for a criteria

In (SELECT [qry_find_items_missing_allparts].[tblboms.itemnumber])


qry_find_items_missing_allparts finds the parts which are missing from the all parts table I am sure my syntax is wrong but I have fooled around with it so much I cant get it.

 

[NOL]

Hi,

Try this ..

delete * from someparts
where Some_Parts.Part_ID not in
(select Distinct Part_ID From All_parts)

If that's what you wanted ..

Good Luk,
Gina