17,377
社区成员
发帖
与我相关
我的任务
分享
update
(select xq.duty_deptid didxq,duty_deptname dnamexq,duty_deptnameall dnameallxq,
d.deptid didd,d.deptname dnamed,d.deptnameall dnamealld
from xq,user ,dept d
where xq.duty_userid = user.userid
and user.fk_deptid = d.deptid)
set didxq = didd,dnamexq = dnamed,dnameallxq=dnamealld