Copy Data from one Table to another

Total Post:46

Points:324

 1998  View(s)
Ratings:
Rate this:
Copy all records data from Table1 into Table2 matching on the ID.
Don't know how to write the query to make this happen. Can anyone help?
Thanks!
Sandy
  1. Re: Copy Data from one Table to another

    UPDATE Table1

    SET Table1.ID = Table2.ID

    FROM Table1

    INNER

    JOIN Table2

    ON Table2.ID = Table1.ID

Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.