COPY DATA FROM ONE TABLE TO ANOTHER

Total Post:46

Points:324
 1677  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:127

    Points:915
    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!