select count(*)
from d_dkmx d,d_dkjyls l
where l.jyrq >= to_date('2002-5-1','yyyy-mm-dd')
and l.jyrq <= to_date('2002-5-31','yyyy-mm-dd')
and d.zh = l.zh
and d.jkbh = l.jkbh(+)
and d.zjrq = to_date('2002-5-31','yyyy-mm-dd') select count(*)
from d_dkmx d,d_dkjyls l
where l.jyrq >= to_date('2002-5-1','yyyy-mm-dd')
and l.jyrq <= to_date('2002-5-31','yyyy-mm-dd')
and d.zh = l.zh
and d.jkbh(+) = l.jkbh
and d.zjrq = to_date('2002-5-31','yyyy-mm-dd') 都不能返回所有需要的行,好象外连接没起作用??!!
from d_dkmx d,d_dkjyls l
where l.jyrq >= to_date('2002-5-1','yyyy-mm-dd')
and l.jyrq <= to_date('2002-5-31','yyyy-mm-dd')
and d.zh = l.zh
and d.jkbh = l.jkbh(+)
and d.zjrq = to_date('2002-5-31','yyyy-mm-dd') select count(*)
from d_dkmx d,d_dkjyls l
where l.jyrq >= to_date('2002-5-1','yyyy-mm-dd')
and l.jyrq <= to_date('2002-5-31','yyyy-mm-dd')
and d.zh = l.zh
and d.jkbh(+) = l.jkbh
and d.zjrq = to_date('2002-5-31','yyyy-mm-dd') 都不能返回所有需要的行,好象外连接没起作用??!!
解决方案 »
- 求Oracle定义anycusor的包PKdual
- 网站上经常会报错,ORA-04030 ORA-12560
- 如何设置dataguard的数据保护模式
- ssh架构,spring声明式事物(oracle数据库)不回滚
- 向oracle中插入blob对象为什么要行锁
- 求一个SQL语句(insert into(AA,BB) select acct_item_id_seq.NEXTVAL,id,sum(charge) from TABLE group by id
- 学习oracle SG的经验和方法
- sys用户为什么不能连接呢?
- 一个联合查询问题,高手帮忙,拜托啦
- 在VC中连接oracle数据库的问题,恳请斑竹及大家帮忙,急!谢谢!!
- 要microsoft odbc for oracle驱动一定要安装oracle单机版吗?
- 数据库导出导入问题
from d_dkmx d,d_dkjyls l
where l.jyrq >= to_date('2002-5-1','yyyy-mm-dd')
and l.jyrq <= to_date('2002-5-31','yyyy-mm-dd')
and d.zh = l.zh(+)
and d.jkbh = l.jkbh(+)
and d.zjrq = to_date('2002-5-31','yyyy-mm-dd')
and d.zh = l.zh
and d.jkbh = l.jkbh