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@]