1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| SELECT T_TIERS, T_TARIFTIERS, YTC_TARIFSPECIAL, GA_CODEARTICLE, YTS_TARIFTIERS, YTS_TARIFSPECIAL, GA_LIBELLE, GA_FAMILLENIV1, GA_FAMILLENIV2, GA_FAMILLENIV3,
YTS_PRIXNET, YTS_PRIXBRUT, YTS_REMISE1, YTS_REMISE2, YTS_REMISE3, YTS_FAMILLENIV1, YTS_FAMILLENIV2,
YTS_FAMILLENIV3, YTS_DATEFIN
FROM TIERS
LEFT JOIN TIERSCOMPL on TIERSCOMPL.YTC_AUXILIAIRE = TIERS.T_AUXILIAIRE
LEFT JOIN YTARIFS on TIERSCOMPL.YTC_TARIFSPECIAL = YTARIFS.YTS_TARIFSPECIAL
LEFT JOIN ARTICLE on ARTICLE.GA_CODEARTICLE = YTARIFS.YTS_CODEARTICLE
WHERE T_TIERS = '010007'AND GA_FERME != 'X' AND GA_LIBREART3 = 003 AND GA_LIBREART2 = 002 AND YTS_DATEFIN > getdate()
UNION
SELECT T_TIERS, T_TARIFTIERS,YTC_TARIFSPECIAL,GA_CODEARTICLE, YTS_TARIFTIERS, YTS_TARIFSPECIAL, GA_LIBELLE, GA_FAMILLENIV1, GA_FAMILLENIV2, GA_FAMILLENIV3,
YTS_PRIXNET, YTS_PRIXBRUT, YTS_REMISE1, YTS_REMISE2, YTS_REMISE3, YTS_FAMILLENIV1, YTS_FAMILLENIV2,
YTS_FAMILLENIV3, YTS_DATEFIN
FROM TIERS
LEFT JOIN TIERSCOMPL on TIERSCOMPL.YTC_AUXILIAIRE = TIERS.T_AUXILIAIRE
LEFT JOIN YTARIFS on TIERS.T_TARIFTIERS = YTARIFS.YTS_TARIFTIERS
LEFT JOIN ARTICLE on ARTICLE.GA_CODEARTICLE = YTARIFS.YTS_CODEARTICLE
WHERE T_TIERS = '010007' AND GA_FERME != 'X' AND GA_LIBREART3 = 003 AND GA_LIBREART2 = 002 AND YTS_DATEFIN > getdate() |
Partager