Сумма в Union

Вторник, 23 Апреля 2019 г. 09:20 + в цитатник

Есть у меня запрос с Union....
Работает....

SELECT matsuP.codm, Sum([mqq]*getqb([MAIN1]![code])) AS Кмат, MAINM.MARKA, MAINM.COMMENT
FROM MAIN1 INNER JOIN (((tprcs INNER JOIN techproc ON tprcs.code = techproc.cm1) INNER JOIN spztmp ON tprcs.code = spztmp.cdtp) INNER JOIN (MAINM INNER JOIN matsuP ON MAINM.CODE = matsuP.codm) ON techproc.code = matsuP.codetp) ON MAIN1.code = spztmp.codm1
WHERE (((MAIN1.sernn)=16))
GROUP BY matsuP.codm, MAINM.MARKA, MAINM.COMMENT;
UNION SELECT matsuPcp.codm, Sum([mqq]*getqb([MAIN1]![code])) AS Кмат, MAINM.MARKA, MAINM.COMMENT
FROM (MAIN1 INNER JOIN ((tprcs INNER JOIN techproc ON tprcs.code = techproc.cm1) INNER JOIN spztmp ON tprcs.code = spztmp.cdtp) ON MAIN1.code = spztmp.codm1) INNER JOIN (specpr INNER JOIN (MAINM INNER JOIN matsuPcp ON MAINM.CODE = matsuPcp.codm) ON specpr.code = matsuPcp.codetp) ON techproc.code = specpr.specprN
WHERE (((MAIN1.sernn)=16))
GROUP BY matsuPcp.codm, MAINM.MARKA, MAINM.COMMENT;