Třídová akce

Kód:

7

Tělo:

SELECT SUM(SD2Amount), SUM(SD2Qunatity), SUM(PT2Qunatity), MDSID FROM
(
SELECT MDS.ID MDSID, SUM(MDS2.LocalTAmount) SD2Amount, SUM(MDS2.Quantity) SD2Qunatity
  ,(SELECT SUM(PT2.MaterialQuantity) FROM ProductionTasks2 PT2 WHERE PT2.MaterialRow_ID = MDS2.ID) PT2Qunatity
FROM PLMJobOrders JO
JOIN PLMJONodes N ON N.Parent_ID = JO.ID
JOIN PLMJOInputItems MIPL ON MIPL.Owner_ID = N.ID
JOIN PLMMIPLMaterialDistrib MD ON MD.Parent_ID = MIPL.ID
JOIN Storedocuments2 MDS2 ON MD.StoreDocument2_id = MDS2.ID
JOIN Storedocuments MDS ON MDS.ID = MDS2.Parent_ID
WHERE
  JO.ID = :JOID
GROUP BY MDS.ID, MDS2.ID
) A
GROUP BY MDSID

Generated by ABRA Software a.s. 27.10.2021 16:34:49