select *
from (SELECT COUNT (*),'FTTH' AS FTTH
FROM TAR_STATION T
WHERE FLDEX29 LIKE '%5%') P Natural
JOIN (SELECT COUNT(FLDID) AS 商务楼宇, 'FTTH' FTTH
FROM TAR_STATION A
WHERE A.FLDISFILLING = '1'
AND A.FLDBUILDSTATUS NOT IN ('3', '5')
AND A.FLDEX29 IS NOT NULL
AND A.FLDEX29 LIKE '%5%'
AND A.FLDEX68 = '1') Q Natural
JOIN (SELECT COUNT(*) AS 工业园区, 'FTTH' FTTH
FROM TAR_STATION S
WHERE S.FLDISFILLING = '1'
AND S.FLDBUILDSTATUS NOT IN ('3', '5')
AND S.FLDEX29 IS NOT NULL
AND S.FLDEX29 LIKE '%5%'
AND S.FLDEX68 = '2') W Natural
JOIN (SELECT COUNT(*) AS 专业市场, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '3') E Natural
JOIN (SELECT COUNT(*) AS 商业街, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'
AND D.FLDEX68 = '4') O Natural
JOIN (SELECT COUNT(*) AS 单点客户, 'FTTH' FTTH
FROM TAR_STATION D
WHERE D.FLDISFILLING = '1'
AND D.FLDBUILDSTATUS NOT IN ('3', '5')
AND D.FLDEX29 IS NOT NULL
AND D.FLDEX29 LIKE '%5%'