COPY DATA FROM ONE TABLE TO ANOTHER

sandy taylor

Total Post:46

Points:324
Posted by  sandy taylor
 1569  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. Uttam Misra

    Post:126

    Points:906
    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

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!