Copy Data from one Table to another

Total Post:46

Points:324
 1966  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. Post:131

    Points:943
    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.