Write Delete SQL Query in Access 2007

[SAURABH]

HI Experts,

I have to delete data from 1 table based on condition from other table.

eg:-
Table1 fields are ID & Name
& Table2 fields are ID & Name .

Now i want to delete those records from Table1 in which ID does not match
with that of table 2.
ID is the primary key.

I have tried many things but it is not working.

Help Required......

can anyone write that SQL statement for me..............

Plz help

 

[Douglas J. Steele]

DELETE FROM Table1 WHERE ID NOT IN (SELECT ID FROM Table2)