merge into yyglbxq.curr a
using (select khh, mdlhh from cdktj.cktj where mdlhh = 'jt1' or mdlhh = 'JT1' or mdlhh = 'jt4' or mdlhh = 'JT4') b
on a.core_cust_id = b.khh
when matched then
update set a.belg_org_id = b.mdlhh
else
ignore;
using (select khh, mdlhh from cdktj.cktj where mdlhh = 'jt1' or mdlhh = 'JT1' or mdlhh = 'jt4' or mdlhh = 'JT4') b
on a.core_cust_id = b.khh
when matched then
update set a.belg_org_id = b.mdlhh
else
ignore;