I'm trying to clean up a table that has a lot of old data in it, about 4 million extra rows to be exact. I want to delete all rows from table1 where fieldA isn't matched in any of the rows of table2 in fieldB how would I write that?

Thanks!