Code :
SELECT Compte, SUM(QtA), SUM(PrixA), SUM(QtB), SUM(PrixB) FROM ( SELECT A.Compte, IF(B.ref,NULL,A.qt) AS QtA, IF(B.ref,NULL,A.qt * A.prix) AS PrixA FROM A, IF(B.ref,A.qt,NULL) AS QtB, IF(B.ref,A.qt * A.prix,NULL) AS PrixB LEFT JOIN B ON B.ref = A.ref ) GROUP BY Compte
|