在这个帖中,也有一些资料
http://topic.csdn.net/u/20081024/09/8cb00d9f-d662-4a63-96a2-17d4f2c86085.htmlselect m.jig_code, n.line, n.div_code, n.netjph, n.att
from (select CODE_KEY3 as jig_code
from pro_t_a05
where CODE_GRP = 'CONVEYCODE'
and CODE_KEY3 <> '*'
and CODE_KEY1 = 'C1'
and CODE_KEY2 = 'JI000') m
left join (select NVL(c.IRECT_LINE_MAN, 0.0) as line,
a.jig_code as jig_code,
a.DIV_CODE as div_code,
NVL(b.NET_JPH, 0.0) as netjph,
NVL(b.ACTTACKTIME, 0.0) as att
from PRO_T_I08 a,
(select * from PRO_T_Q03 where head = 'C1') b,
(select sum(DIRECT_LINE_MAN) as IRECT_LINE_MAN, jig_code
from PRO_T_I08
group by jig_code) c
where a.div_code = 'JI000'
and a.jig_code = b.jig_code(+)
and c.jig_code = a.jig_code) n on m.jig_code = n.jig_code插入数据后那条查询语句竟然查不出来,还必须在PRO_T_I08有相应的jig_code才能查询数据,,,怎么改啊
http://topic.csdn.net/u/20081024/09/8cb00d9f-d662-4a63-96a2-17d4f2c86085.htmlselect m.jig_code, n.line, n.div_code, n.netjph, n.att
from (select CODE_KEY3 as jig_code
from pro_t_a05
where CODE_GRP = 'CONVEYCODE'
and CODE_KEY3 <> '*'
and CODE_KEY1 = 'C1'
and CODE_KEY2 = 'JI000') m
left join (select NVL(c.IRECT_LINE_MAN, 0.0) as line,
a.jig_code as jig_code,
a.DIV_CODE as div_code,
NVL(b.NET_JPH, 0.0) as netjph,
NVL(b.ACTTACKTIME, 0.0) as att
from PRO_T_I08 a,
(select * from PRO_T_Q03 where head = 'C1') b,
(select sum(DIRECT_LINE_MAN) as IRECT_LINE_MAN, jig_code
from PRO_T_I08
group by jig_code) c
where a.div_code = 'JI000'
and a.jig_code = b.jig_code(+)
and c.jig_code = a.jig_code) n on m.jig_code = n.jig_code插入数据后那条查询语句竟然查不出来,还必须在PRO_T_I08有相应的jig_code才能查询数据,,,怎么改啊
解决方案 »
- 急啊!一对多问题!
- 老大们来看看:oralce存储过程问题?
- 求大神帮我看看这条语句
- ORA-12560问题,在线求解中......
- 急,这样的SQL语句怎么写?我知道sqlserver但不知道oracle
- ASP连接ORACLE运行正常,但有时会出现数据无法读取情况
- 关于动态SQL的问题
- 安装Oracle的Client端时,遇到问题多多,希望你的指导!!!!
- <求教>Oracle EBS开发 ——数据库有多行记录,表单却只能检索到一条记录
- oracle修改用户名后,oracle客户端及应用程序连接不上数据库
- 求助:SP2-0042: 未知命令"xxxx" -- 其余行忽略 这种错误怎么捕获呢
- Oracle 无效数字错误
select NVL(c.IRECT_LINE_MAN, 0.0) as line,
a.jig_code as jig_code,
a.DIV_CODE as div_code,
NVL(b.NET_JPH, 0.0) as netjph,
NVL(b.ACTTACKTIME, 0.0) as att
from PRO_T_I08 a,
(select * from PRO_T_Q03 where head = 'C1') b,
(select sum(DIRECT_LINE_MAN) as IRECT_LINE_MAN, jig_code
from PRO_T_I08
group by jig_code) c
where a.div_code = 'JI000'
and a.jig_code = b.jig_code(+)
and c.jig_code = a.jig_code
这个有数据结合上面的才有。你把这个再拆分仔细检查下。到底是哪个地方出错的。一步一步来。我们没实际环境不好检查
如果两个操作是在一个会话里就不需要。------------
学习:
请问下面的"(+)"是什么意思啊?
and a.jig_code = b.jig_code(+)