Delete rows from TABLE-A that do not match TABLE-B

[ronwmon]

I have a situation where I need to delete rows from TABLE-A. I have another table (TABLE-B) that contains a list of ID numbers that match some of the rows in the TABLE-A. I need to delete all rows in TABLE-A that do not match TABLE-B. The common field name in both tables is site_no.

Any ideas on the best way to accomplish this?

Thanks,

Ron--

 

[unclejimbob]

Dunno about it being the best way but here is one way.

DELETE FROM [table-a]
FROM [table-a] ta LEFT JOIN [table-b] tb ON
ta.site_no = tb.site_no WHERE tb.site_no IS NULL