树展开.sql

行业应急系统 包括: 应急系统（待遇核发） 发放系统 开发环境:Delphi5 (sp1)+ Oracle 8.05 MultiExport是一个可以将数据按指定字段倒出

--显示行业节点

SELECT  DMB.DMMC,COUNT(*) DMCOUNT
FROM  tDMB DMB,tff_dwxx DW
WHERE  DMB.DM(+)=DW.SSHY and DMB.ZDBZ='SSHY'
GROUP BY DMMC
ORDER BY DMMC

--显示单位节点
SELECT 	DW.SSDWID,DW2.DWMC,COUNT(*) DMCOUNT
FROM 	tff_DWXX DW,tff_DWXX DW2,tDMB
WHERE 	DW.SSHY=tDMB.DM AND tDMB.ZDBZ='SSHY'
	AND DW.SSDWID=DW2.DWID_FF AND tDMB.DMMC='铁道'
GROUP BY DW.SSDWID,DW2.DWMC

--显示组
SELECT DWMC,DWID_FF
FROM tff_DWXX
WHERE ssdwid='1000000000'