SELECT CATEGORIE.categorie_article, SUM(VENTES.nb_ventes) as total FROM CATEGORIES, VENTES WHERE VENTES.idCat=CATEGORIES.4_ref GROUP BY (VENTES.idCat)
SELECT CATEGORIE.categorie_article, SUM(VENTES.nb_ventes) as total, SUBSTRING(ARTICLES.reference) as categ FROM CATEGORIES, VENTES WHERE categ=CATEGORIES.4_ref GROUP BY (categ)
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question