ce qui pose probleme c'est : A4AUCD"!!"A4AWCD AS CT
Voir ci dessous
SELECT
ALL T01.A4AHCD, A4AUCD"!!"A4AWCD AS CT, T02.B3JACF, T01.A4AKNB,
T01.A4AHNB, T01.A4AZTX, T01.A4AJDT, T01.A4EINA, T02.B3NGND,
T03.BLBXCD, T03.BLAIQT01, T03.BLABVA01
FROM XCAVE01G/GCA4REL1 T01,
XCAVE01G/GFB3CPP T02,
CBI/VENTES2005 T03
WHERE T01.A4AKNB = T02.B3AKNB
AND T01.A4AHNB = T02.B3AHNB
AND T01.A4AKNB = T03.BLAKNB
AND T01.A4AHNB = T03.BLAHNB
AND( A4AUCD"!!"A4AWCD = ' Q02'
AND SUBSTR(B3JACF, 1, 1) <> 'B'
AND A4AJDT >= 1051001
OR A4AUCD"!!"A4AWCD = ' Q02'
AND SUBSTR(B3JACF, 1, 1) <> 'B'
AND A4AJDT = 0)
ORDER BY T02.B3JACF ASC