BI Publisher and Union Select (11.1.1.5.0)
Any help greatly appreciated.
Here the SQL I am trying (without the union it works fine):
Table Union:
select F4211.DCTO as DCTO,
F4211.CO as CO,
F4211.AN8 as AN8,
F4211.TRDJ as TRDJ,
F4211.NXTR as NXTR,
F4211.UORG as UORG,
F4211.AEXP as AEXP,
F4211.ECST as ECST,
F0101.ALPH as ALPH
from F0101 F0101,
F4211 F4211
where F4211.AN8=F0101.AN8
union select F42119.DCTO as DCTO,