Column or globale Variable not found

Error msg: > DataSource.Error: ODBC: ERROR [42S22] [IBM][System i Access > ODBC-stuurprogramma][DB2 for i5/OS]SQL0206 - Kolom of globale > variabele AADETX niet gevonden. Details: > DataSourceKind=Odbc > DataSourcePath=dsn=I-Make > OdbcErrors=[Table] Google translate of the error message: Column or global variable AADETX not found. Request:

SELECT

A.G1AATX AS Artikel,
A.GIG4NU ATP_aantal_cum,
A.G1HADT BEGIN_periode

FROM MIFA.VIS#MOGEM.V1G1REP A

LEFT JOIN (
SELECT 

B.AAAATX AS Artikel,
B.AADATX Artikelgroep,
B.AADETX Artikeltype

FROM MIFA.VIS#MOGEM.VIAAREP 

WHERE B.AADATX  'SMEE'
AND B.AADATX  'LIJM'
AND B.AADATX  'UMEC'
AND B.AADETX ='I'

GROUP BY AAAATX
) B on B.AAAATX = A.G1AATX

LEFT JOIN (
SELECT 

C.ELAATX AS Artikel,
C.ELCXST Status

FROM MIFA.VIS#MOGEM.VOELREP

WHERE C.ELCXST IN ('A',' ')

GROUP BY ELAATX
) C on C.ELAATX = A.G1AATX

WHERE A.G1AATX = '4022-480-9858'

The column AADETX the error reffers to does exist. If i look it up in just the table i can find the specifiek data. I'm trying to fix the duplicates errors i got from the request below: First attempt:

SELECT

A.G1AATX As Artikel, 
A.G1G4NU ATP_aantal_cum,
A.G1HADT Begindatum_periode,
B.AADETX I

FROM

MIFA.VIS#MOGEM.V1G1REP A
LEFT OUTER JOIN MIFA.VIS#MOGEM.VIAAREP B on B.AAAATX=A.G1AATX
LEFT OUTER JOIN MIFA.VIS#MOGEM.VOELREP C on C.ELAATX=A.G1AATX

WHERE B.AADATX  'SMEE'
AND B.AADATX  'LIJM'
AND B.AADATX  'UMEC'
AND C.ELCXST IN ('A',' ')
AND B.AADETX ='I'
AND A.G1AATX = '4022-480-9858'