Update Join

Oracle:

update t1 set col = (select col from t2 where t1.col=t2.col) where exists(select col from t2 where t1.col=t2.col)

delete from t1 where exists(select col from t2 where t1.col = t2.col)

MSSQL:

update t1 set col = t2.col from t2 where t1.col=t2.col

转载于:https://blog.51cto.com/enthen/821188