update table1
set
f1=(select b.f1 from table2 b,table1 a where a.id=b.id),
f2=(select b.f2 from table2 b,table1 a where a.id=b.id),
f3=(select b.f3 from table2 b,table1 a where a.id=b.id);[@more@]
set
f1=(select b.f1 from table2 b,table1 a where a.id=b.id),
f2=(select b.f2 from table2 b,table1 a where a.id=b.id),
f3=(select b.f3 from table2 b,table1 a where a.id=b.id);[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/43132/viewspace-923818/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/43132/viewspace-923818/