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
Copy Data from one Table to another
Ask by Anonymous User
Updated 18 Oct 2010
UPDATE Table1
SET Table1.ID = Table2.ID
FROM Table1
INNER
JOIN Table2
ON Table2.ID = Table1.ID