How do i delete unmatched data in my Query ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I ran a query with Table 1 matching it on Table 2 .
I found a lot of unmatched data.
How can I delete the data from Table 1 without doing it manually?
 
Use a subquery to create a delete query:

DELETE [Table 1].* FROM [Table 1] WHERE [Table 1].[ID] Not In (SELECT [ID]
FROM [Table 2];);
 
Back
Top