Delete duplicates from both tables

[dakpluto]

I have two tables. I need to find the duplicates between both tables (easy part, already done) The hard part, I then need to remove the records from BOTH Tables. For the life of me I can't figure out how to do this. Deleting from one table is fairly simple, but I can't figure out how to delete from the second table also.

[June7]

DELETE sql action can work for only one table at a time. Problem is as soon as you delete from one table you find query will no loner work and can't delete from second tabe.

Suggest you write the found records to a temp table then run DELETE sql for each of the tables based on records of the temp table.

[dakpluto]

DELETE sql action can work for only one table at a time. Problem is as soon as you delete from one table you find query will no loner work and can't delete from second tabe.

Suggest you write the found records to a temp table then run DELETE sql for each of the tables based on records of the temp table.

oh yeah, didn't even think to just move them to a new table. Thanks! That should work perfectly. Sigh, brain was just too fried to think of the simple task, lol