---这里t_pre_credit_xycnxx_bm 的cnnr更新到 T_CREDITPROMISE的context中
merge into T_CREDITPROMISE A
using(select id,CNNR from t_pre_credit_xycnxx_bm B) TMP
on (A.ID=TMP.ID)
when matched then
update set A.CONTEXT=TMP.CNNR
---这里t_pre_credit_xycnxx_bm 的cnnr更新到 T_CREDITPROMISE的context中
merge into T_CREDITPROMISE A
using(select id,CNNR from t_pre_credit_xycnxx_bm B) TMP
on (A.ID=TMP.ID)
when matched then
update set A.CONTEXT=TMP.CNNR