1、Oracle 连表修改
merge into t_user t1 using (select * from t_class) t2 on(t1.userId=t2.userId) when matched then update set t1.name=t2.name
2、Sql server 连表修改
UPDATE b SET b.ProductSN=p.productsn FROM t_user b INNER JOIN t_student p ON b.MainSN=p.MainSN
标签：Join,userId,t2,t1,连表,修改,server From： https://www.cnblogs.com/zoro-zero/p/17865477.html