04-04-2017, 11:09 PM
(آخر تعديل لهذه المشاركة: 05-04-2017, 09:32 AM بواسطة محمد عبد العزيز.)
الكود بعد التصحيح
SELECT T.code_prod, T.dest_prod, (SELECT Nz( sum(Qte),0) FROM achat AS E WHERE E.code_prod = T.code_prod) AS QTE_E, (SELECT Nz(sum(qte_vent),0) FROM vendre AS S WHERE S.code_prod = T.code_prod) AS QTS, [QTE_E]-[QTS] AS Reste
FROM PRODUIT AS T;
SELECT T.code_prod, T.dest_prod, (SELECT Nz( sum(Qte),0) FROM achat AS E WHERE E.code_prod = T.code_prod) AS QTE_E, (SELECT Nz(sum(qte_vent),0) FROM vendre AS S WHERE S.code_prod = T.code_prod) AS QTS, [QTE_E]-[QTS] AS Reste
FROM PRODUIT AS T;