proc 全连接 full join 报错问题
以下全联结语句在pl/sql 下可以执行,到了proc就不能执行了
select a.boss_seq, b.boss_seq
from posp_trans_info a FULL JOIN posp_trans_info b on a.boss_seq = b.boss_seq ;
报错:
PCC-S-02201, Encountered the symbol "FULL" when expecting one of the following:
; , for, union, connect, group, having, intersect, minus,
order, start, where, with,
我换了左连接 left outer join 一样的,除非换成另外一种写法 a.boss_seq(+) = b.boss_seq
问高人,全连接的这个proc错误如何处理?