Delete query

  • Thread starter Thread starter Ellen
  • Start date Start date
E

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
 
DELETE FROM table1 WHERE ID# IN (SELECT ID# FROM table2)

Hope This Helps
Gerald Stanley MCSD
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top