语句1:select count(*)
from v_gzjbwl_fund_amabzzpay a
left join v_gzjbwl_fund_amabzzbankroll b on (a.member_code = b.member_code and a.fund_billnum = b.fund_billnum
and (b.dd_type_settlement <> '承兑汇票' or b.dd_type_settlement <> '商业承兑汇票')
and b.fund_billnum is not null);语句2:
select count(*)
from v_gzjbwl_fund_amabzzpay a
left join v_gzjbwl_fund_amabzzbankroll b on (
(b.dd_type_settlement <> '承兑汇票' or b.dd_type_settlement <> '商业承兑汇票') and
a.member_code = b.member_code and a.fund_billnum = b.fund_billnumand b.fund_billnum is not null);
结果分别为:
906040
822不知道为什么
from v_gzjbwl_fund_amabzzpay a
left join v_gzjbwl_fund_amabzzbankroll b on (a.member_code = b.member_code and a.fund_billnum = b.fund_billnum
and (b.dd_type_settlement <> '承兑汇票' or b.dd_type_settlement <> '商业承兑汇票')
and b.fund_billnum is not null);语句2:
select count(*)
from v_gzjbwl_fund_amabzzpay a
left join v_gzjbwl_fund_amabzzbankroll b on (
(b.dd_type_settlement <> '承兑汇票' or b.dd_type_settlement <> '商业承兑汇票') and
a.member_code = b.member_code and a.fund_billnum = b.fund_billnumand b.fund_billnum is not null);
结果分别为:
906040
822不知道为什么
解决方案 »
- 将数据从SQL 2008远程导入到Oracle表中的问题,求救~~~~~~
- 不显示删除回复显示所有回复显示星级回复显示得分回复 ORA-04091: 表 HNTELANT.XB_UIMCARD 发生了变化, 触发器/函数不能读它
- 请教:海量数据库联机数据与归档数据的规划策略
- oracle中存储过程返回list,出现“子程序或游标'XXXX' 已在程序包说明中说明,必须在程序包体中对其进行定义。”
- 请教数据库名(db_name)、实例名(instance_name)、ORACLE_SID 有何区别
- 函数
- to_char()问题!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- 简单问题,但还没有解决,我再问!!!!!!
- 我用sql创建的临时表怎么没有记录?(急)
- 如何使用索引
- oracle 无法启动监听
- ORA-04030: 在尝试分配 字节 (,) 时进程内存不足
a.member_code = b.member_code and a.fund_billnum = b.fund_billnum的作用
没看见数据,我们只能给你说理论上市一致的。
http://topic.csdn.net/u/20120807/10/7577e13a-387f-49a3-ac12-16c156a7ffd5.html?seed=1338974221&r=79336480#r_79336480