select t_info.INVOICE_NO as HOKEN_Y_KBN1,
t_code1.code_data1 as T1CODE_DATA1
from Q02D_INVOICE_INFO t_info,
Q02MCODE t_code1
where t_info.HOKEN_Y_KBN=t_code1.code_code(+)
and 'M123'=t_code1.code_mstkbn(+)
and t_code1.code_data3(+)='123'
select t_info.INVOICE_NO as HOKEN_Y_KBN1,
t_code1.code_data1 as T1CODE_DATA1
from Q02D_INVOICE_INFO t_info,
(select code_data1,code_code,code_mstkbn,code_data3 from Q02MCODE where code_mstkbn='M123' and code_data3='123') t_code1
where t_info.HOKEN_Y_KBN=t_code1.code_code(+) 上面两个语句结果是一样的,但我认为下面更加合理,不知大家意见如何?
t_code1.code_data1 as T1CODE_DATA1
from Q02D_INVOICE_INFO t_info,
Q02MCODE t_code1
where t_info.HOKEN_Y_KBN=t_code1.code_code(+)
and 'M123'=t_code1.code_mstkbn(+)
and t_code1.code_data3(+)='123'
select t_info.INVOICE_NO as HOKEN_Y_KBN1,
t_code1.code_data1 as T1CODE_DATA1
from Q02D_INVOICE_INFO t_info,
(select code_data1,code_code,code_mstkbn,code_data3 from Q02MCODE where code_mstkbn='M123' and code_data3='123') t_code1
where t_info.HOKEN_Y_KBN=t_code1.code_code(+) 上面两个语句结果是一样的,但我认为下面更加合理,不知大家意见如何?
解决方案 »
- oracle如何进行数据分类排名?
- Incremental checkpoint
- 一台Server能同时支持9i的INet和10G的INet Connection么?
- Windows XP + VMWare Server 1.0.6 + CentOS 5.2 + Oracle 10g Rac (10.2.0.1)安装文档 3
- SQL的问题 急!!!
- 自动增长的一个简单问题
- select * from FOR UPDATE 和 select * from FOR UPDATE NOWAIT 有什么区别?
- 我的用客户端连上ORACLE,怎么我的SQLPULS打开中文全是乱码,执行语句后看不到结果是什么
- 双网卡问题
- 请问:P4中为何不能安装oracle9i?
- 9i 的企业管理器选择 "Oracle Management Server" 方式
- 怎么修改这个TO_DATE()语句
select t_info.HOKEN_Y_KBN as HOKEN_Y_KBN1,
t_code1.code_data1 as T1CODE_DATA1
from Q02D_INVOICE_INFO t_info,
Q02MCODE t_code1
where t_info.HA_TORISAKI_CD='FZ013'
and t_info.HA_JIGYO_CD='13'
and t_info.INVOICE_NO='IVNO003'
and t_info.HOKEN_Y_KBN=t_code1.code_code(+)
and 'M123'=t_code1.code_mstkbn(+);select t_info.HOKEN_Y_KBN as HOKEN_Y_KBN1,
t_code1.code_data1 as T1CODE_DATA1
from Q02D_INVOICE_INFO t_info,
Q02MCODE t_code1
where t_info.HA_TORISAKI_CD='FZ013'
and t_info.HA_JIGYO_CD='13'
and t_info.INVOICE_NO='IVNO003'
and t_info.HOKEN_Y_KBN=t_code1.code_code(+)
and 'M123'=t_code1.code_mstkbn;
'M123'=t_code1.code_mstkbn会过滤掉code_mstkbn<>‘M123’的数据,而'M123'=t_code1.code_mstkbn(+)不会过滤掉code_mstkbn<>‘M123’的数据,不匹配的t_code1.code_data1 就会取空值