a.jan,b.febFROM (select ab07.aab001,aae002,aab137 jan from ab07,ab01_t where ab07.aab001=ab01_t.aab001 and ab07.aae140='3' and substr(aae002,5,2)='01') a, (select aab001,aae002,nvl(aab137,0) feb from ab07 where aae140=3 and substr(aae002,5,2)='02') b where
a.aab001=b.aab001 and substr(a.aae002,1,4)=substr(b.aae002,1,4)
aab001是主键? where a.aab001=b.aab001(+)
select a.aab001,
a.jan,b.febFROM (select ab07.aab001,aae002,aab137 jan from ab07,ab01_t where ab07.aab001=ab01_t.aab001 and ab07.aae140='3' and substr(aae002,5,2)='01') a, (select aab001,aae002,nvl(aab137,0) feb from ab07 where aae140=3 and substr(aae002,5,2)='02') b where
a.aab001=b.aab001(+) and substr(a.aae002,1,4)=substr(b.aae002,1,4)(+)看看改成这样 如何?
运行newsjb的修改,错误提示:sql command not properly ended
刚找到了一种解决方法: select a.aab001,
a.jan,b.febFROM (select ab07.aab001,aae002,aab137 jan from ab07,ab01_t where ab07.aab001=ab01_t.aab001 and ab07.aae140='3' and substr(aae002,5,2)='01') a, (select aab001,aae002,nvl(aab137,0) feb from ab07 where aae140=3 and substr(aae002,5,2)='02') b where
a.aab001=b.aab001(+) and (substr(a.aae002,1,4)=substr(b.aae002,1,4) or b.aae002 is null)多谢各位!
a.jan,b.febFROM
(select ab07.aab001,aae002,aab137 jan from ab07,ab01_t where ab07.aab001=ab01_t.aab001 and ab07.aae140='3' and substr(aae002,5,2)='01') a,
(select aab001,aae002,nvl(aab137,0) feb from ab07 where aae140=3 and substr(aae002,5,2)='02') b
where
a.aab001=b.aab001 and substr(a.aae002,1,4)=substr(b.aae002,1,4)
where a.aab001=b.aab001(+)
a.jan,b.febFROM
(select ab07.aab001,aae002,aab137 jan from ab07,ab01_t where ab07.aab001=ab01_t.aab001 and ab07.aae140='3' and substr(aae002,5,2)='01') a,
(select aab001,aae002,nvl(aab137,0) feb from ab07 where aae140=3 and substr(aae002,5,2)='02') b
where
a.aab001=b.aab001(+) and substr(a.aae002,1,4)=substr(b.aae002,1,4)(+)看看改成这样 如何?
select a.aab001,
a.jan,b.febFROM
(select ab07.aab001,aae002,aab137 jan from ab07,ab01_t where ab07.aab001=ab01_t.aab001 and ab07.aae140='3' and substr(aae002,5,2)='01') a,
(select aab001,aae002,nvl(aab137,0) feb from ab07 where aae140=3 and substr(aae002,5,2)='02') b
where
a.aab001=b.aab001(+) and (substr(a.aae002,1,4)=substr(b.aae002,1,4) or b.aae002 is null)多谢各位!