两查询结果相加后没数据了
日期：2014-05-18 浏览次数：20559 次
两查询结果相加后没有数据了。
------解决方案--------------------
- SQL code
SELECT TOP 1 SUM(QTY) FROM MRT WHERE JOBNO=RESVT.JOBNO AND MRT.CODE=RESVT.CODE AND P_CODE=RESVT.P_CODE
- SQL code
SELECT TOP 1 SUM(KT.QTY)
FROM KT INNER JOIN KTUDF ON(KT.ITEMNO=KTUDF.ITEMNO AND KT.KINNO=KTUDF.KINNO)
WHERE KT.KTYPE='02' AND KTUDF.GDH=(CASE WHEN MASTERJOB = '' THEN JOBNO ELSE MASTERJOB END) AND KT.CODE=RESVT.CODE
- SQL code
select sum(n.col1+m.col1) col
from
(
SELECT TOP 1 SUM(QTY)col1 FROM MRT WHERE JOBNO=RESVT.JOBNO AND MRT.CODE=RESVT.CODE AND P_CODE=RESVT.P_CODE
)m,
(
SELECT TOP 1 SUM(KT.QTY)col1
FROM KT INNER JOIN KTUDF ON(KT.ITEMNO=KTUDF.ITEMNO AND KT.KINNO=KTUDF.KINNO)
WHERE KT.KTYPE='02' AND KTUDF.GDH=(CASE WHEN MASTERJOB = '' THEN JOBNO ELSE MASTERJOB END) AND KT.CODE=RESVT.CODE
)n
------解决方案--------------------
- SQL code
select sum(n.col1+m.col1) col
from
(
SELECT TOP 1 SUM(QTY)col1 FROM MRT WHERE JOBNO=RESVT.JOBNO AND MRT.CODE=RESVT.CODE AND P_CODE=RESVT.P_CODE
)m,
(
SELECT TOP 1 SUM(KT.QTY)col1
FROM KT INNER JOIN KTUDF ON(KT.ITEMNO=KTUDF.ITEMNO AND KT.KINNO=KTUDF.KINNO)
WHERE KT.KTYPE='02' AND KTUDF.GDH=(CASE WHEN MASTERJOB = '' THEN JOBNO ELSE MASTERJOB END) AND KT.CODE=RESVT.CODE
)n
where m.col=n.col
--你的关联条件
------解决方案--------------------
- SQL code
select sum(col1+col2) col
from
(
col1=(SELECT TOP 1 SUM(QTY)col1 FROM MRT WHERE JOBNO=RESVT.JOBNO AND
MRT.CODE=RESVT.CODE AND P_CODE=RESVT.P_CODE
),
col2=(SELECT TOP 1 SUM(KT.QTY)col1
FROM KT INNER JOIN KTUDF
ON(KT.ITEMNO=KTUDF.ITEMNO AND KT.KINNO=KTUDF.KINNO)
WHERE KT.KTYPE='02' AND
KTUDF.GDH=(CASE WHEN MASTERJOB = '' THEN JOBNO ELSE MASTERJOB END)
AND KT.CODE=RESVT.CODE
))
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
