22,300
社区成员




update a set a.[name]=b.[name] from a,b where a.id=b.id
方法二:update a set a.[name]=b.[name] from a join b on a.id=b.id
update a set a.[name] = b.[name] from a join b on a.id = b.id
update a set a.[name] = b.[name] from a join b on a.id = b.id
UPDATE a as A Left jOin b as B SET A.name=B.name WHERE A.id=B.id