update (select table1.abc aname,table2.abc bname from table1,table2 where
table1.id=table2.id) set aname=bname;