SELECT *,(SELECT SUM(E.quantiteE) FROM MvtEntree E WHERE E.article=A.article)-(SELECT SUM(S.quantiteS) FROM MvtSortie S WHERE S.article=A.article) FROM article A
SELECT A.*, SUM(E.quantiteE) AS SumE, SUM(S.quantiteS) AS SumS FROM Article A LEFT JOIN MvtEntree E ON E.article=A.article LEFT JOIN MvtSortie S ON S.article=A.article
UPDATE ... SET ..., Champ=(SELECT ... ) WHERE ...
Modifié par jordane45 le 6/11/2016 à 19:31
Il manque les GROUP BY
6 nov. 2016 à 19:35
... GROUP BY A.article