johnkainn
asked on
update from Backup table
I have 2 tables. Table1(Id,ColA,ColB,ColC) and TableBackup(Id,ColA,ColB,C olC).
Table2 has the same columns as Table1.
I would like to update ColA and ColB in Table1 with ColA and ColB from TableBackup. The Id is the same in both tables.
How is best to do this?
Table2 has the same columns as Table1.
I would like to update ColA and ColB in Table1 with ColA and ColB from TableBackup. The Id is the same in both tables.
How is best to do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
oops, use "TableBackup" instead of "Table2" in the join clause