我在数据库中进行七张表的关联查询,where后的条件有12个,其中很多表都不直接关联,现在查询不到我想要的数据,请问各位高手,当多张表进行关联的时候,应该注意哪些问题呢,where后的查询条件是不是有什么先后顺序???select
GI.GUARANTYID as GUARANTYID,
GI.GUARANTYTYPE as GUARANTYTYPE,
case
when GI.GUARANTYTYPE like '2010%' then '020'
when GI.GUARANTYTYPE like '2020%' then '030'
when GI.GUARANTYTYPE like '1010%' then '040'
when GI.GUARANTYTYPE like '1020%' then '050'
else '070' end as CLASSIFY,
GI.CONFIRMVALUE as CONFIRMVALUE,
BD.BUSINESSTYPE as BUSINESSTYPE,
BD.SERIALNO as BUSINESSSERIALNO,
BD.BALANCE as BUSINESSBALANCE,
GC.SERIALNO as GUARANTYCONTRACTID,
'2011/09/20' as SESSIONID
from BUSINESS_DUEBILL BD,
BUSINESS_CONTRACT BC,
GUARANTY_CONTRACT GC,
lmt_tree_node LMT,
AGR_CRE_SEC_RELA AGR,
GUARANTY_INFO GI, GUARANTY_RELATIVE GR
where
GI.guarantyId =GR.guarantyId
and GR.GCCONTRACTNO =GC.serialNo
and GC.serialNo=BC.RELATIVESERIALNO
and GC.serialNo= AGR.GUR_SERIALNO
and BC.SERIALNO=BD.RelativeSerialNo2
and BC.SerialNo =AGR.SERIALNO
and AGR.CREDITOBJTYPE = 'BusinessContract'
and BC.relativelmtid=LMT.lmtid
and GC.ContractStatus = '020'
and BD.Balance >0
and (GC.GUARANTYTYPE='050' or GC.GUARANTYTYPE='060')
and BD.InputDate = '2011/09/20'
GI.GUARANTYID as GUARANTYID,
GI.GUARANTYTYPE as GUARANTYTYPE,
case
when GI.GUARANTYTYPE like '2010%' then '020'
when GI.GUARANTYTYPE like '2020%' then '030'
when GI.GUARANTYTYPE like '1010%' then '040'
when GI.GUARANTYTYPE like '1020%' then '050'
else '070' end as CLASSIFY,
GI.CONFIRMVALUE as CONFIRMVALUE,
BD.BUSINESSTYPE as BUSINESSTYPE,
BD.SERIALNO as BUSINESSSERIALNO,
BD.BALANCE as BUSINESSBALANCE,
GC.SERIALNO as GUARANTYCONTRACTID,
'2011/09/20' as SESSIONID
from BUSINESS_DUEBILL BD,
BUSINESS_CONTRACT BC,
GUARANTY_CONTRACT GC,
lmt_tree_node LMT,
AGR_CRE_SEC_RELA AGR,
GUARANTY_INFO GI, GUARANTY_RELATIVE GR
where
GI.guarantyId =GR.guarantyId
and GR.GCCONTRACTNO =GC.serialNo
and GC.serialNo=BC.RELATIVESERIALNO
and GC.serialNo= AGR.GUR_SERIALNO
and BC.SERIALNO=BD.RelativeSerialNo2
and BC.SerialNo =AGR.SERIALNO
and AGR.CREDITOBJTYPE = 'BusinessContract'
and BC.relativelmtid=LMT.lmtid
and GC.ContractStatus = '020'
and BD.Balance >0
and (GC.GUARANTYTYPE='050' or GC.GUARANTYTYPE='060')
and BD.InputDate = '2011/09/20'
解决方案 »
- 求高手点拨“Oracle公司的中国知识产权保护渠道与办法”。
- OracleConnection怎么写呢
- 学习oracle数据库之路
- Oracle中如何筛选LONG类型的数据?
- 看似简单,想破头皮,毫无头绪
- 那位高手帮小弟看一下那里错了!存储过程
- 我这个怎么解决好啊?用触发器还是用程序解决?
- 怎么实现字段自动加一????
- 64位的2008系统 装32位oracle 配置的报表需要64位
- 关于Oracle存储过程for循环的问题,菜鸟急求解答
- 数据库设技中,关于ID的必要性?
- oracle11g+win7:ORA-12154: TNS:could not resolve the connect identifier specified
with aa as(select )个方法没有使用过,能稍微详细点吗?举个简单的例子也可以。