两个不同的SQL语句在Oracle中怎么同时执行
引用 4 楼 woshiyanliu 的回复:Quote: 引用 1 楼 bw555 的回复:结果怎么呈现？最好有数据，举例说明原始数据样式和需要的结果的样式
第一个数据呈现方式：
第二个数据呈现方式：
最后需要展现的方式：
第一个SQL语句：
SELECT TSC.CONS_NAME,
TV.JCL
FROM T_SYS_CONSTANT TSC
LEFT JOIN
(SELECT FZ.CONS_VALUE,
DECODE(NVL(FM.FMSJ, 0), 0, 0, ROUND(NVL(FZ.FZSJ, 0) / NVL(FM.FMSJ, 0) * 100))
|| '%' AS JCL
FROM
(SELECT TSC.CONS_VALUE,
NVL(B.FZSJ, 0) FZSJ
FROM T_SYS_CONSTANT TSC
LEFT JOIN
(SELECT T3.OCRFACTORS_TYPE,
COUNT(1) AS FZSJ
FROM H_CHECK_CRESULT_MAIN_TB T
INNER JOIN H_CHECK_CRDETAIL_TB T1
ON T.CRESULT_MAIN_TB_ID = T1.CRESULT_MAIN_TB_ID
INNER JOIN H_BASICCONFIG_POINT_HAZARDS_TM T2
ON T1.CHEPOINT_MAIN_ID = T2.CHEPOINT_MAIN_ID
INNER JOIN H_BASICCONFIG_CHEMICAL_MAIN_TM T3
ON T1.UNION_ID = T3.CHEMICAL_MAIN_ID
INNER JOIN
(SELECT VLD_SITE_ID
FROM VLD_SITE
WHERE ORG_STATUS = 'A'
CONNECT BY PRIOR VLD_SITE_ID = VLD_PARENT_SITE_ID
START WITH VLD_SITE_ID = 10
) VS
ON T.VLD_SITE_ID = VS.VLD_SITE_ID
WHERE T1.CHECK_RESULT IS NOT NULL
AND TO_CHAR(T.YEAR) = to_char(sysdate, 'yyyy' )
GROUP BY T3.OCRFACTORS_TYPE
) B ON B.OCRFACTORS_TYPE = TSC.CONS_VALUE
WHERE TSC.CONS_CATALOG = 'OCRFACTORS_TYPE'
) FZ
LEFT JOIN
(SELECT TSC.CONS_VALUE,
NVL(A.FMSJ, 0) FMSJ
FROM T_SYS_CONSTANT TSC
LEFT JOIN
(SELECT T3.OCRFACTORS_TYPE,
SUM(DECODE(T1.CHECK_RATE, 1, 12, 2, 4, 3, 2, 4, 1, 5, 6, 6, 3, 0)) AS FMSJ
FROM H_CHECK_CPLAN_MAIN_TB T
INNER JOIN H_CHECK_PDETAIL_TB T1
ON T.CPLAN_MAIN_TB_ID = T1.CPLAN_MAIN_TB_ID
INNER JOIN H_BASICCONFIG_POINT_HAZARDS_TM T2
ON T1.CHEPOINT_MAIN_ID = T2.CHEPOINT_MAIN_ID
INNER JOIN H_BASICCONFIG_CHEMICAL_MAIN_TM T3
ON T1.UNION_ID = T3.CHEMICAL_MAIN_ID
INNER JOIN
(SELECT VLD_SITE_ID
FROM VLD_SITE
WHERE ORG_STATUS = 'A'
CONNECT BY PRIOR VLD_SITE_ID = VLD_PARENT_SITE_ID
START WITH VLD_SITE_ID = 10
) VS
ON T.VLD_SITE_ID = VS.VLD_SITE_ID
WHERE
TO_CHAR(T.CHECK_YEAR) = to_char(sysdate, 'yyyy' )
AND T.IS_FINISH = '1'
GROUP BY T3.OCRFACTORS_TYPE
) A ON TSC.CONS_VALUE = A.OCRFACTORS_TYPE
WHERE TSC.CONS_CATALOG = 'OCRFACTORS_TYPE'
) FM ON FZ.CONS_VALUE = FM.CONS_VALUE
ORDER BY FZ.CONS_VALUE
) TV ON TSC.CONS_VALUE = TV.CONS_VALUE
WHERE TSC.CONS_CATALOG = 'OCRFACTORS_TYPE'
第二个的SQL语句：
SELECT TSC.CONS_NAME,
NVL(T.LXCBDS, 0) AS LXCBDS
FROM T_SYS_CONSTANT TSC
LEFT JOIN
(SELECT A.OCRFACTORS_TYPE,
COUNT(1) AS LXCBDS
FROM
(SELECT T3.OCRFACTORS_TYPE,
T1.CHEPOINT_MAIN_ID
FROM H_CHECK_CRESULT_MAIN_TB T
INNER JOIN H_CHECK_CRDETAIL_TB T1
ON T.CRESULT_MAIN_TB_ID = T1.CRESULT_MAIN_TB_ID
INNER JOIN H_BASICCONFIG_POINT_HAZARDS_TM T2
ON T1.CHEPOINT_MAIN_ID = T2.CHEPOINT_MAIN_ID
INNER JOIN H_BASICCONFIG_CHEMICAL_MAIN_TM T3
ON T1.UNION_ID = T3.CHEMICAL_MAIN_ID
INNER JOIN
(SELECT VLD_SITE_ID
FROM VLD_SITE
WHERE ORG_STATUS = 'A'
CONNECT BY PRIOR VLD_SITE_ID = VLD_PARENT_SITE_ID
START WITH VLD_SITE_ID = 10
) VS
ON T.VLD_SITE_ID = VS.VLD_SITE_ID
WHERE T1.CHECK_RESULT = '0'
AND to_char(T.YEAR) = to_char(sysdate, 'yyyy')
GROUP BY T3.OCRFACTORS_TYPE,
T1.CHEPOINT_MAIN_ID
) A
INNER JOIN
(SELECT T3.OCRFACTORS_TYPE,
T1.CHEPOINT_MAIN_ID
FROM H_CHECK_CRESULT_MAIN_TB T
INNER JOIN H_CHECK_CRDETAIL_TB T1
ON T.CRESULT_MAIN_TB_ID = T1.CRESULT_MAIN_TB_ID
INNER JOIN H_BASICCONFIG_POINT_HAZARDS_TM T2
ON T1.CHEPOINT_MAIN_ID = T2.CHEPOINT_MAIN_ID
INNER JOIN H_BASICCONFIG_CHEMICAL_MAIN_TM T3
ON T1.UNION_ID = T3.CHEMICAL_MAIN_ID
INNER JOIN
(SELECT VLD_SITE_ID
FROM VLD_SITE
WHERE ORG_STATUS = 'A'
CONNECT BY PRIOR VLD_SITE_ID = VLD_PARENT_SITE_ID
START WITH VLD_SITE_ID = 10
) VS
ON T.VLD_SITE_ID = VS.VLD_SITE_ID
WHERE T1.CHECK_RESULT = '0'
-- AND T.YEAR = {2}
AND to_char(T.YEAR) = to_char(sysdate, 'yyyy')-1
GROUP BY T3.OCRFACTORS_TYPE,
T1.CHEPOINT_MAIN_ID
) B ON A.OCRFACTORS_TYPE = B.OCRFACTORS_TYPE
AND A.CHEPOINT_MAIN_ID = B.CHEPOINT_MAIN_ID
GROUP BY A.OCRFACTORS_TYPE
) T ON TSC.CONS_VALUE = T.OCRFACTORS_TYPE
WHERE TSC.CONS_CATALOG = 'OCRFACTORS_TYPE'
ORDER BY TSC.CONS_VALUE
这两个SQL语句查到大分别是最后呈现的是最后的结果中的一行，我目前没有数据库结构，也没办法写新的SQL语句，只能在他们说的SQL语句上进行修改，请问怎么把这两个SQL语句连在一起，出现最后呈现的那种效果，只要连起来就行了
------解决思路----------------------
with T1 AS (查询1的查询语句)
,T2 AS(查询2的查询语句)
select ‘检测率’ as 监测点类型,
max(decode(CONS_NAME,'毒物',JCL)) 毒物,
max(decode(CONS_NAME,'粉尘',JCL)) 粉尘,
……
from T1
UNION ALL
select ‘超标点数’ as 监测点类型,
max(decode(CONS_NAME,'毒物',LXCBDS)) 毒物,
max(decode(CONS_NAME,'粉尘',LXCBDS)) 粉尘,
……
from T2
给你写了个大概，剩余的你自己补齐吧
ps:帖子发一次就行了，不需要重复发帖
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
