树展开.sql

来自「行业应急系统 包括: 应急系统（待遇核发） 发放系统 开」· SQL 代码 · 共 20 行

--显示行业节点

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'