Delete Query: Delete record in Table1 using data in Table2 1

[wwwjont]

Hi,

I am trying to delete records in one table using data in another table. Table1 would have forename surname dob and table2 has just dobs. Where dobs match in Table1 and Table2 I want to delete the record in table1. I have tried various querys without success. (I am working in Access) Any help would be gratefully appreciated.

Thanks
John

 

[PHV]

One way:
DELETE FROM Table1
WHERE dob IN (SELECT dobs FROM table2)

Another way:
DELETE Table1.*
FROM Table1 INNER table2 ON Table1.dob = table2.dobs

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

One way:
DELETE FROM Table1
WHERE dob IN (SELECT dobs FROM table2)

Another way:
DELETE Table1.*
FROM Table1 INNER JOIN table2 ON Table1.dob = table2.dobs

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886