Delete query

[Ellen]

Hello,

I have two tables, table1 and table2. I'd like to delete
the records in table1 where the ID# is the same in both
tables. This way there will be no duplicate records when
I append table1 with table2. (Table2 has the most recent
update.)

Thank you in advance.

Ellen

 

[Gerald Stanley]

DELETE FROM table1 WHERE ID# IN (SELECT ID# FROM table2)

Hope This Helps
Gerald Stanley MCSD

 

[Guest]

Yes!!! It's perfect!!

-----Original Message-----
DELETE FROM table1 WHERE ID# IN (SELECT ID# FROM table2)

Hope This Helps
Gerald Stanley MCSD
.