mysql:
update 表A a,表B b set a.xx=b.xx where a.id=b.id;
oracle
update 表A set a.xx=(select b.xx from 表B where a.id = b.id) where exists(select 1 from b.xx where a.id = b.id)