解决:在inset values(后面加上要插入表的前缀即可);
merge into bak22
using bak2on (bak22.keyid=bak2.keyid)
when matched then
update set planno=1+bak2.planno
when not matched then
insert values(bak2.KEYID,
bak2.INTFTYPE,
bak2.AREACODE,
bak2.CALLTIME,
bak2.SERIALNO,
bak2.PLANNO,
bak2.SUBSCODE,
bak2.XML,
bak2.DEALSTAT,
bak2.JSON,
bak2.DEALRESULT,
bak2.DIRECTION,
bak2.SUCCEED,
bak2.REMARK,
bak2.CONTROL,
bak2.TRY_TIMES,
bak2.HANDLE_LEVEL,
bak2.HANDLE_TIME_START,
bak2.HANDLE_TIME_END,
bak2.RECEIVE_TIME,
bak2.SYSCODE,
bak2.ARCHIVE_MODE,
bak2.C_XML_TIME);