34,576
社区成员
发帖
与我相关
我的任务
分享
select * from mt t1
left join ManagerAccount t2 on
t1.mt_zh = t2.ManagerAcc_account and
t1.mt_kmh = t2.ManagerAcc_subAcc and
t1.mt_cur =t2.ManagerAcc_cur
where t2.ManagerAcc_account is null
update t2
set t2.bbb = t1.aaa
from manageraccount t2
right join mt t1 on
t1.mt_zh = t2.ManagerAcc_account and
t1.mt_kmh = t2.ManagerAcc_subAcc and
t1.mt_cur =t2.ManagerAcc_cur
where t2.bbb is null