1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
|
SELECT
article.IDArticle AS IDArticle,
article.RefArticle AS RefArticle,
article.Designation AS Designation,
article.DateCreation AS DateCreation,
article.QuantitéStock AS QuantitéStock,
article.StockMin AS StockMin,
article.StokAlerte AS StokAlerte,
article.Emplacement AS Emplacement,
article.IDSousFamille AS IDSousFamille,
article.Photo AS Photo,
article.IDAuthentification AS IDAuthentification,
famille.IDFamille AS IDFamille,
famille.NomFamille AS NomFamille,
sousfamille.NomSousFamille AS NomSousFamille
FROM
article,
famille,
sousfamille
WHERE
article.IDSousFamille=sousfamille.IDSousFamille
AND
sousfamille.IDFamille= famille.IDFamille
AND
(
article.IDAuthentification = {PIDAuthentification}
) |
Partager