1 2 3 4
| SELECT dbo_ARTICLES.COD_ART, dbo_ARTICLES.DGN, dbo_ARTICLES.COD_FAM, dbo_ARTICLES.COD_SOU_FAM, dbo_ARTICLES.PRX_VEN_HT_1, dbo_ARTICLES.PRX_VEN_HT_2, dbo_ARTICLES.DEB_TRF_1, dbo_ARTICLES.DEB_TRF_2, dbo_ARTICLES.QTE_ATE, dbo_ARTICLES.STK_REEL, dbo_ARTICLES.SML, Max(dbo_ART_DERNIERES_VENTES.Date_Intégrale) AS MaxDeDate_Intégrale, dbo_ART_DERNIERES_VENTES.Client_Livré
FROM dbo_ARTICLES LEFT JOIN dbo_ART_DERNIERES_VENTES ON dbo_ARTICLES.COD_ART=dbo_ART_DERNIERES_VENTES.Code_article
WHERE (dbo_ART_DERNIERES_VENTES.Client_Livré)="02063"
GROUP BY dbo_ARTICLES.COD_ART, dbo_ARTICLES.DGN, dbo_ARTICLES.COD_FAM, dbo_ARTICLES.COD_SOU_FAM, dbo_ARTICLES.PRX_VEN_HT_1, dbo_ARTICLES.PRX_VEN_HT_2, dbo_ARTICLES.DEB_TRF_1, dbo_ARTICLES.DEB_TRF_2, dbo_ARTICLES.QTE_ATE, dbo_ARTICLES.STK_REEL, dbo_ARTICLES.SML, dbo_ART_DERNIERES_VENTES.Client_Livré; |
Partager