(急)没有人回呀,版主帮帮忙好吗?看文中的SQL语句还有没有更好的写法,先谢了
希望有人可以帮我看一下这个语句还可以怎么写的更好。先谢了select JFDM, DLDM, JMJTotal from (
select a.SeniorCode as ZDM, a.JFCode as JFDM, b.GDDLDMEJ as DLDM, b.JMJTotal from
dlmis.tzdicjf a,
(select ZLDWDMC,GDDLDMEJ,sum(jmj) jmjtotal from
(select ZLDWDMC,GDDLDMEJ,pcmj jmj,GDDLDM from dlgis.mzdl500
union all select ZLDWDMC,GDDLDMEJ,pcmj jmj,GDDLDM from dlgis.mzdl2000
union all select ZLDWDMC,GDDLDMEJ,(pcmj-kcmj) jmj,GDDLDM from dlgis.mzdl10000
union all select ZLDWDMC,GDDLDMEJ,dzdlmj jmj,GDDLDM from dlgis.dzdl
union all select ZLDWDMC1 ZLDWDMC,GDDLDMEJ,xzdlmj1 jmj,GDDLDM from dlgis.xzdl
union all select ZLDWDMC2 ZLDWDMC,GDDLDMEJ,xzdlmj2 jmj,GDDLDM from dlgis.xzdl)
where InStr(GDDLDM,'K') = 0
group by ZLDWDMC,GDDLDMEJ) b
where a.JFCode like b.ZLDWDMC(+) ) c, dlmis.Tzdicdl d
where c.DLDM = d.wordfield79(+) and ZDM = (select wordfield58 from dlmis.tzdiczm where instr(wordfield59,Param101) > 0 and rownum = 1) order by JFDM;
Param101为输入字段。
[ 本帖最后由 supy 于 2006-6-21 10:53 编辑 ] 是不是发到别的板块试试 这么复杂,真晕 为什么要嵌那么多层? 能不能把表的大概结构,以及你打算实现什么样的查询写出来,直列出sql语句,而且还这么多,看着很乱 这什么编码风格。。太乱了。。。可读性太差了。。
页:
[1]