left outer or inner join (via JDBC driver)
722075May 31 2011 — edited May 31 2011I'm trying to enter a manual SQL statement in BI Publisher (so without using the query builder where a left join is marked with "(+)") (using JDBC driver)
But I don't manage to define a left inner join (so my F0902 is my primary table where I want to fetch eg a few other descriptions of whatever in other tables)
It returns in error when I run the view query.
When I leave the simple join (so without left join) like that (see below), then it will pull up the records that exist in all 3 tables. So records with blanks in F0902 are not pulled up. So can anyone tell me how to define such an left join in BIP? Or is that not supported ?
Stefan
Thanks
SELECT F0902.CO,
F0902.LT,
F0902.CTRY,
F0902.FY,
F0902.AID,
F0902.MCU,
F0902.OBJ,
F0902.SUB,
F0902.SBLT,
F0902.SBL,
F0902.AN07,
F0901.AID,
F0901.DL01,
F0901.R001,
F0901.R002,
F0901.R003,
F0101.AN8,
F0101.ALPH
FROM JDE.F0902,
JDE.F0901,
JDE.F0101
WHERE F0902.AID = F0901.AID
and F0902.SBL = F0101.AN8
and F0902.CO ='00421'
and F0902.LT ='AA'
and F0902.FY =10
and F0902.AID ='30430981'
and F0902.MCU =' 42102999'
and F0902.OBJ >'499999'