参考如下语法
update student A
set (A.name,a.dq) =
(select B.bname,b.bdq
from newstudent B
where B.Bid = A.id
and A.dq = 10
)
where exists (select 1
from newstudent B
where B.Bid = A.id
and A.dq = 10
);
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024