【ORACLE】【SQL】两表关联更新

MSSQL

update A set A.id=B.id from A, B where A.name=B.name

Oracle

update a set a.id= (select b.id from b where a.NAME = b.NAME) where exists (select 1 from b where A.name=B.name)