1 2 3 4 5 6 7 8 9
| SELECT T.ACTmat, T.ABRmat, T.STATmat, T.REFmat, T.DESmat, T.UNImat, Sum(T.QTE) AS QTE, T.PRIXmat
FROM (SELECT ACTmat, ABRmat, STATmat, REFmat, DESmat, UNImat, QTE, PRIXmat FROM REQe
UNION
SELECT ACTmat, ABRmat, STATmat, REFmat, DESmat, UNImat, QTE, PRIXmat FROM REQm
UNION
SELECT ACTmat, ABRmat, STATmat, REFmat, DESmat, UNImat, QTE, PRIXmat FROM REQpm
UNION
SELECT ACTmat, ABRmat, STATmat, REFmat, DESmat, UNImat, QTE, PRIXmat FROM REQpe ) AS T
GROUP BY T.ACTmat, T.ABRmat, T.STATmat, T.REFmat, T.DESmat, T.UNImat, T.PRIXmat; |
Partager