an outer join cannot be specified on a correlation column
select
( select nvl(sum(p.settle_pq),0) from pub_e_pq_amt p where p.prc_code != '00000000' and p.rcvbl_amt_id > 0 and p.line_id=gl.line_id(+) ) as 用户用电量from g_line
本文共 271 字,大约阅读时间需要 1 分钟。
an outer join cannot be specified on a correlation column
select
( select nvl(sum(p.settle_pq),0) from pub_e_pq_amt p where p.prc_code != '00000000' and p.rcvbl_amt_id > 0 and p.line_id=gl.line_id(+) ) as 用户用电量from g_line
转载于:https://www.cnblogs.com/qylbg/p/3248237.html