1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
|
SELECT DISTINCT F_ARTICLE.AR_Ref, F_ARTICLE.AR_Design,F_ARTICLE.FA_CodeFamille,F_ARTICLE.AR_UniteVen,F_ARTICLE.AR_PrixAch,F_ARTICLE.AR_PrixVen,F_ARTICLE.AR_PrixTTC,F_ARTICLE.AR_Gamme1,F_ARTICLE.AR_SuiviStock,
F_ARTICLE.AR_Stat01,F_ARTICLE.AR_Stat02,F_ARTICLE.AR_Stat03, F_ARTICLE.AR_CodeBarre,
F.CT_Num,F.AF_RefFourniss,F.AF_Colisage,F.AF_PrixDev,F.AF_Devise,F.AF_Remise,
G.EG_Enumere,
E.AE_CodeBarre,
E.AE_Ref
FROM "MABDSAGE".dbo.F_ARTICLE F_ARTICLE
RIGHT OUTER JOIN F_ARTFOURNISS F ON F_ARTICLE.AR_REF = F.AR_REF
LEFT OUTER JOIN F_ARTGAMME G ON F_ARTICLE.AR_REF = G.AR_Ref
LEFT OUTER JOIN F_ARTENUMREF E ON F_ARTICLE.AR_REF = E.AR_REF
WHERE AR_Gamme1 = '1' OR AR_Gamme1='0'
GROUP BY F_ARTICLE.AR_Ref, F_ARTICLE.AR_Design,F_ARTICLE.FA_CodeFamille,F_ARTICLE.AR_UniteVen,F_ARTICLE.AR_PrixAch,F_ARTICLE.AR_PrixVen,F_ARTICLE.AR_PrixTTC,F_ARTICLE.AR_Gamme1,F_ARTICLE.AR_SuiviStock,
F_ARTICLE.AR_Stat01,F_ARTICLE.AR_Stat02,F_ARTICLE.AR_Stat03, F_ARTICLE.AR_CodeBarre,
F.CT_Num,F.AF_RefFourniss,F.AF_Colisage,F.AF_PrixDev,F.AF_Devise,F.AF_Remise,
G.EG_Enumere,
E.AE_CodeBarre,
E.AE_Ref |
Partager