SQLServer
update S_USER set account=p.account from S_PERSON p where p.id=S_USER.person_id;
Oracle
update table_name t1 set (a,b,c)=( select a,b,c from table_name_2 t2 where t1.a=t2.a)
2 where exists(select 1 from table_name_2 t2 where t1.a=t2.a)
MySql
UPDATE b SET ClientName = a.name FROM a,b WHERE a.id = b.id