Sunday, August 1, 2010

Update 1 table with data from another using values from table 2

 Update 1 table with data from another using values from table 2

UPDATE table1, table2
SET table1.xyz = table2.xyz,
    table1.abc = table2.abc,
    table1.zamboni = table2.zamboni
WHERE table1.id = table2.id

No comments:

Post a Comment