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
241417-Oct-2010
Updated on 18-Oct-2010
Home / DeveloperSection / Forums / Copy Data from one Table to another
Uttam Misra
18-Oct-2010UPDATE Table1
SET Table1.ID = Table2.ID
FROM Table1
INNER
JOIN Table2
ON Table2.ID = Table1.ID