I'm trying to do some data cleanup, and I need to delete
rows in a table based on the primary key not existing in
another table. Here's the pseudocode:
Delete from table 1
where table 1.primary key isn't in table 2.primary key
Any ideas how to create the join?