Delete where two fields both match record in other table

[Galaxiom]

Having a metal block.

What is the SQL for deleting a record when two of its fields both match corresponding fields in a record of another table?

 

[Galaxiom]

I did come up with this query which works.

DELETE FROM Table1
WHERE Table1.Field1 & Table1.Field2
IN (
SELECT Table2.Field1 & Table2.Field2 AS Combined
From Table2
);

However with over 2200 records in Table1 and 1500 in Table2, Access was really chugging to produce the Datasheet view of the query.

I have noticed that DELETE FROM WHERE IN SELECT is incredibly slow compared to just the select or a DELETE WHERE. I guess it makes sense since IN has to compare every record line by line but even then it seem slow.

There has to be a better way.

As it turned out the SQL server wasn't going to let me delete from the linked table anyway. I think it was too tied up in dependencies despite my permission being explicitly set.

I ended up deleting all the records from the table at the server and then appending the ones I wanted to keep which I have previously saved.