Delete Records where record exists in another table

[jinu4ever]

Hi Folks

I have two tables. Archive1 and Archive2 with exactly the same field setup.
I want to delete from Archive1 where the record exists in Archive2.

I've seen a lot of question of this sort on the web and here but I can't quite figure it out. Surely the query must be simple.

Cheers
AC

 

[Trevor G]

Something like this may work for you

DELETE FROM Archive1
WHERE Archive1.Field1 & Archive1.Field2
IN
( SELECT Archive2.Field1 & Archive2.Field2 AS Combined
From Archive2 );