Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionSELECT Table1.ref, Table1.codearticle, Table1.designation, Sum(IIf([Table2]![couleur]="gris",[Table2]![qte],0)) AS gris, Sum(IIf([Table2]![couleur]="vert",[Table2]![qte],0)) AS vert, Sum(IIf([Table2]![couleur]="bleu",[Table2]![qte],0)) AS bleu FROM Table1 LEFT JOIN Table2 ON (Table1.codearticle Table2.codearticle) AND (Table1.ref Table2.ref) GROUP BY Table1.ref, Table1.codearticle, Table1.designation;
SELECT Table1.ref, Table1.codearticle, Table1.designation, Table2.couleur, Table2.qte FROM Table1 INNER JOIN Table2 ON (Table1.designation Table2.designation) AND (Table1.codearticle Table2.codearticle) AND (Table1.ref = Table2.ref);