Da brauchst du 2 SQL's:

delete from table1 a
where exists (select * from table2 b where a.key=b.key)

delete from table2 a
where not exists (select * from table1 b where a.key=b.key)