SELECT DISTINCT S.* ,ART.* ,SUM(S.qte) AS arrive ,SUM(S.qte) - (ART.vendu) AS diff FROM stocks S LEFT JOIN ( SELECT A.articleVendu, A.id_prod ,SUM(A.articleQuant) as vendu FROM articles A GROUP BY A.id_prod) ART ON ART.id_prod = S.id_pros GROUP BY S.id_pros
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question
Tu n'as pas répondu à toutes mes questions...
SELECT DISTINCT S.* ,ART.* ,SUM(S.qte) AS arrive ,SUM(S.qte) - (ART.vendu) AS diff FROM stocks S LEFT JOIN ( SELECT A.articleVendu, A.id_prod ,SUM(A.articleQuant) as vendu FROM articles A GROUP BY A.id_prod) ART ON ART.id_prod = S.id_pros GROUP BY S.id_pros
SUM(S.qte) AS arriverenvoie 900 au lieu de 300.
SELECT DISTINCT S.* ,ART.* ,SUM(S.qte) AS arrive ,SUM(S.qte) - (ART.vendu) AS diff ,S.id_pros ,P.id_pros ,P.article FROM stocks S LEFT JOIN ( SELECT A.articleVendu, A.id_prod ,SUM(A.articleQuant) as vendu FROM articles A GROUP BY A.id_prod) ART ON ART.id_prod = S.id_pros JOIN produits P ON S.id_pros = P.id_pros GROUP BY S.id_pros
SELECT DISTINCT S.* ,ART.* ,SUM(S.qte) AS arrive ,SUM(S.qte) - (ART.vendu) AS diff ,S.id_pros ,P.id_pros ,P.article FROM stocks S LEFT JOIN ( SELECT A.articleVendu, A.id_prod ,SUM(A.articleQuant) as vendu FROM articles A GROUP BY A.id_prod) ART ON ART.id_prod = S.id_pros JOIN produits P ON S.id_pros = P.id_pros GROUP BY S.id_pros