I'm using MS SQL and have 2 tables.
table1 has 384 records
table2 has 252 records (that are duplicates of 252 of table1's rows)
I can perform the join to tell me there are 252 rows that match:
SELECT COUNT(*) AS Expr1
FROM table1 INNER JOIN
table2 ON table1.part_number = table2.part_number
How do I format the query so I can DELETE the 252 rows of table1 so I'm left with only the 132 rows that aren't contained in table2?