I'm trying to write a report that has an outer join to a constant. I have the following SQL:
WHERE ext_trad_ref.cmpy_num(+) = trade.cmpy_num
AND ext_trad_ref.trad_tag(+) = trade.trad_tag
AND ext_trad_ref.ref_type(+) = 'DEA'
The first two lines were easy enough to replicate in the admin edition and work fine, however the 3rd line is the sticking point. I originally set it up as a condition as normal but I can't see anywhere where you can specify that it's to be an outer join.
Has anyone an idea of how to do this. The report is perfect except for this 1 line.