oracle缺少函数,为什么这个merge语句会报缺失ON关键字啊？

最初由 qinlu1219 发布

[B][php]merge into tbl_callback_time dest using

(select ta.id,

max(ta.first_agent) first_agent,

max(ta.first_call) first_call,

max(ta.second_agent) second_agent,

max(ta.second_call) second_call,

max(ta.last_agent) last_agent,

max(ta.last_call) last_call,

min(ta.call_off_flag) call_off_flag

from(select r.sample_id id,

decode(r.result_code,'1',r.USER_ID) first_agent,

decode(r.result_code, '1', r.create_time) first_call,

decode(r.result_code,'2',r.user_id) second_agent,

decode(r.result_code, '2', r.create_time) second_call,

decode(r.result_code,'3',r.USER_ID) last_agent,

decode(r.result_code, '3', r.create_time) last_call,

decode(s.biz_state,'3',(case when c.CALL_OFF_FLAG not in('0','1','2','3','4