Translating SQL statement to Qlik

[Douwe_KB]

SELECT ABAN8, ABALPH, DRKY, DRDL01 FROM PDTSDTA.F0101, PDTSCTL.F0005

WHERE DRSY='41' AND DRRT='S2' AND ABAN8 = 100

I have this SQL statement which does exactly what I want: for each customer number (ABAN8) give all possible productgroups as follows: 

 however, I can't figure out how to do this in Qlik. I have access to all these JDE tables. Any help is appreciated

[sandeep-singh]

Try this, If the code didn't work, then I request you to share a dummy sample of data for further analysis

PDTSDTA_F0101:
LOAD ABAN8, ABALPH, DRKY, DRDL01
FROM PDTSDTA.F0101;

PDTSCTL_F0005:
LOAD ABAN8, DRSY, DRRT
FROM PDTSCTL.F0005
WHERE DRSY = '41' AND DRRT = 'S2' AND ABAN8 = 100;

Join (PDTSDTA_F0101)
Load ABAN8, DRSY, DRRT
Resident PDTSCTL_F0005;

Drop Table PDTSCTL_F0005;

[MayilVahanan]

Hi

You can directly use this sql statement in Qlik.