UPDATE SELECT

MySQL:
update A inner join(select id,name from B) c on A.id = c.id set A.name = c.name;
ORACLE:
update A set (a,b,c)=(select a,b,c from ida where ida.id=A.id);
update A set a=(select T.a from T where T.id=A.id),b=(select t2.b from t2 where A.id=t2.id)
SQLSERVER:
update a set a.id = b.id from a left join b on a.email=b.email where b.email =‘xxxxxx;

UPDATE SELECT

原文：https://www.cnblogs.com/pingfu/p/14339231.html