34,838
社区成员




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