FROM AADAT80/OP100M2,AADAT80/OP100M1,AADAT80/IC140M,
FROM AADAT80/EC200M,AADAT80/IC100M,AADAT80/DE100M
SELECT T1.SLCSTN,T2.SHSLNM,T2.SHSLA1,T2.SHSLA2,
SELECT T2.SHSLA3,T2.SHSLCI,T2.SHSLST,T2.SHSLZP,
SELECT T1.SLONO ,T2.SHRLNO,T1.SLPTNO,T1.SLPTD1,
SELECT T2.SHCSPO,T1.SLORQY,T1.SLSHQO,T1.SLSHQS,
SELECT T2.SHORCL,T1.SLUNPR,T1.SLLNST,T1.SLEXPR,
SELECT T1.SLRQDT,T1.SLPRDT,T2.SHORDT,T2.SHALBO,
SELECT T3.WBBLT1,T3.WBBLT4,T3.WBBOSQ,T3.WBRSOQ,
SELECT T1.SLUNPO,T1.SLRLNO,
SELECT T1.SLUNQY,T2.SHSHNM,T2.SHHLDC,T2.SHSTCN,
SELECT T4.SLMONO,T5.HSTDT,T5.HDUEDT,T5.HCLSDT,
SELECT T6.ACBAC,T1.SLLNNO
WHERE T1.SLLNST <> 'C' and T6.PMPLNT = 'GSO'
ORDER BY T1.SLPTNO, T1.SLPRDT, T1.SLONO, T1.SLRLNO
JOIN BY T1.SLONO=T2.SHONO and T1.SLRLNO=T2.SHRLNO and
JOIN BY T1.SLWHS=T3.WBWHNO AND T1.SLPTNO = T3.WBPPN and
JOIN BY T1.SLONO=T4.SPONO and T1.SLRLNO=T4.SPRLNO and
JOIN BY T1.SLLNNO=T4.SPLNNO and T4.SLMONO=T5.HZORNO and
JOIN BY T1.SLPTNO=T6.IZPN

I've tried with no success.

TIA
Jeff