Delete query with joined tables

[lhather]

I have two tables that are identical and joined fields that are the key value. One table has over 60,000 records, the other has only 700 or so which has a corresponding records in the larger table.

What I want is to delete the records from the larger table where they equal the records on the smaller table. I keep getting an error to specify the table I want the records deleted from, but cannot figure out how to identify that.

 

[Joe4]

Perhaps this is the stucture you are looking for:

DELETE *
FROM [LargeTableName]
WHERE [MatchingField] In
(SELECT [MatchingField]
FROM [SmallTableName])

 

[lhather]

I am in query design mode. I do not know SQL.

 

[Joe4]

From Query Design Mode, simply change your query from Design View to SQL View. Then you will see the SQL representation of your query. Modify it to match the structure I provided.