Compare two very large tables
So im looking to compare two very large tables.
TableA + TableB
TableA is the table used by the site, and TableB is imported data.
I want to compare the two, and if a row is found in TableA, that matches a row in TableB, I want to delete it (from TableA)
Anyone got any ideas?