SELECT DISTINCT M.IDMarque, M.Marque FROM marque M, rubrique R, articlegenerique A WHERE M.IDMarque=A.IDMarque AND A.IDRubrique= AND A.Valid=1 ORDER BY M.Marque