Try this, I think it'll work:
update table1
set table1.colA=table2.colA, table1.colB=table2.colB where
key1=key2;
|
Results 1 to 4 of 4
Thread: Updating 2 tablesThreaded View
|
Click Here to Expand Forum to Full Width |