SELECT [Stock-Articles].IDarticle, [Stock-Articles].Stock, [Stock-Articles].StockMini, [Stock-Articles].Designation, [Stock-Emplacement].NomEmplacement, [Stock-Categorie].NomCategorie, [Stock-SsCategorie].NomSsCategorie, [Stock-Armoires].LocalisationArmoire, [Stock-Armoires].NomArmoire, [Stock-Articles].IDssCategorie
FROM ((((([Stock-Categorie] RIGHT JOIN ([Stock-SsCategorie] RIGHT JOIN (([Stock-Armoires] RIGHT JOIN [Stock-Emplacement] ON [Stock-Armoires].IDarmoire = [Stock-Emplacement].IDarmoire) RIGHT JOIN [Stock-Articles] ON [Stock-Emplacement].IDemplacement = [Stock-Articles].IDemplacement) ON [Stock-SsCategorie].IDssCategorie = [Stock-Articles].IDssCategorie) ON [Stock-Categorie].IDCatégorie = [Stock-SsCategorie].IDCategorie) LEFT JOIN [Stock-Article-Ressource] ON [Stock-Articles].IDarticle = [Stock-Article-Ressource].IDarticle) LEFT JOIN [Stock-Article-Fournisseur] ON [Stock-Articles].IDarticle = [Stock-Article-Fournisseur].IDarticle) LEFT JOIN Fourni ON [Stock-Article-Fournisseur].CODEFOUR = Fourni.CODEFOUR) LEFT JOIN [Stock-Caracteristiques] ON [Stock-Articles].IDarticle = [Stock-Caracteristiques].IDarticle) LEFT JOIN [Stock-Article-Preventive] ON [Stock-Articles].IDarticle = [Stock-Article-Preventive].IDarticle
GROUP BY [Stock-Articles].IDarticle, [Stock-Articles].Stock, [Stock-Articles].StockMini, [Stock-Articles].Designation, [Stock-Emplacement].NomEmplacement, [Stock-Categorie].NomCategorie, [Stock-SsCategorie].NomSsCategorie, [Stock-Armoires].LocalisationArmoire, [Stock-Armoires].NomArmoire, [Stock-Articles].IDssCategorie
ORDER BY [Stock-Articles].IDarticle;