Delete Query Help

[mccorj1]

I have two tables with the same fields
Table 1 contains 8,000 and some records. Table 2 contains about 2,000 records. I want to delete the records where the pimary key of the two tables match. Can someone help please.

Thank you,

 

[jmersing]

You just basically write a Select query with your join on the keys, targeting the table you want to remove the records from and jusy change it to a Delete query:

DELETE table1.*
FROM table1 LEFT JOIN table2 ON table1.Pkey = table2.Pkey;