1. 多表关联update单字段
update stu t set t.NAME = (select t1.NAME from stu1 t1 where t1.ID = t.ID)
where exists(select 1 from stu1 t1 where t1.ID = t.ID);
2.多表关联update多字段
update stu t set (t.NAME, t.SEX) = (select t1.NAME, t1.SEX from stu1 t1 where t1.ID = t.ID)
where exists(select 1 from stu1 t1 where t1.ID = t.ID);
原文链接:https://blog.csdn.net/yfx000/article/details/83409683