求改1sql，不长
求改一sql，不长
求改一sql
出现的错误：ORA-01719: OR 或 IN 操作数中不允许外部连接运算符 (+)
要怎样改才行呢？
谢谢
------解决方案--------------------
------解决方案--------------------
select b.xm_naem as label , nvl(select sum(rfs) as value from tb_khxx_ry a where b.xmid=a.rbigid and a.rryid in ('008','163') and to_char(a.rupdatetime, 'YYYY')='2012' ),0)from tb_kk b where b.bmid='04171113' group by b.xm_naem,b.xmid
漏了个括号
求改一sql
select b.xm_naem as label,nvl(sum(rfs),0) as value from tb_khxx_ry a,tb_kk b where b.xmid=a.rbigid(+) and rryid(+) in ('008','163') and b.bmid='04171113' and to_char(rupdatetime(+), 'YYYY')='2012' group by b.xm_naem,b.xmid
出现的错误：ORA-01719: OR 或 IN 操作数中不允许外部连接运算符 (+)
要怎样改才行呢？
谢谢
------解决方案--------------------
select
b.xm_naem as label
,
nvl(select sum(rfs as value
from tb_khxx_ry a
where b.xmid=a.rbigid
and a.rryid in ('008','163')
and to_char(a.rupdatetime, 'YYYY')='2012'
),0)
from tb_kk b
where b.bmid='04171113'
group by b.xm_naem,b.xmid
------解决方案--------------------
select b.xm_naem as label , nvl(select sum(rfs) as value from tb_khxx_ry a where b.xmid=a.rbigid and a.rryid in ('008','163') and to_char(a.rupdatetime, 'YYYY')='2012' ),0)from tb_kk b where b.bmid='04171113' group by b.xm_naem,b.xmid
漏了个括号