下面这个句子总是无法执行，提示：无法更新 ON 子句中引用的列: "PT"."GROUP_CODE"

原因：on中 "PT"."GROUP_CODE"已经用作了匹配，无法在update里又做更改，需要去掉匹配才能做update操作。

merge into t_procedure_test pt

using (select ro.route_groupid, ro.group_next group_name,tec.TECHNICSID,tec.TECHNICSNAME

--,tec.MODEL_CODE,tec.ENABLED,tec.MO_NUMBER,tec.ROUTE_CODE, ro.group_code

from t_smo_technics tec ,t_co_route_control ro

where tec.MODEL_CODE='1002000005051' and tec.route_code=ro.route_code and ro.group_next='NBPACK-FINAL-TEST') gro

on (gro.TECHNICSID=pt.TECHNICS_ID and gro.route_groupid=pt.GROUP_CODE)

when matched then

update set pt.GROUP_CODE='Test'

when not matched then

insert (TECHNICS_ID,TECHNICS_NAME,group_name,group_code,test_item_id) values(000,'test','test','000',000);