Ralf if it doesn't automatically pick up the join how do i make it join ?
SQL SELECT * FROM RAMBATHS.AULT2F2.ORDLNORD,RAMBATHS.AULT2F2.PARTS,RAMBATHS.AULT2F2.ORDHDORD,RAMBATHS.AULT2F2.OEP20
where cono40=cono55 and ordn40=ordn55 and cono55=cono35 and catn55=pnum35 and cono55='01' and cono40=cono20 and cusn40=cusn20 and dseq40=dseq20 and Stat55=' '
SQL select * from rambaths.AULT2F2.WHP35
SQL select * from rambaths.aulsprx3.pgmj
Thats the select statements i have, but the file pgmj from the descriptions table has a field called PSAR15 which matches with PGMJ35 from the file PARTS. Because the fields arent the same name Qlikview didnt manage to match them so the file is orphaned. How do i match it ?