Re: Rewrite Full Outer Join into Subquery
Yes. With right join...union...left join, query returned only Actuals dataset and no dataset for Projections.
But if I have only two tables joins for the Actuals (S_orders and S_orders_total) instead of five tables, then right join...union...left join behaves well and returns datasets for both Actuals and Projections. But I need all the five tables in the join because I need the customers details for the orders as well. It looks like joining the extra three tables somehow breaks the join and union rule. Thank you.
Regards,
Regards,
ricky-rich
Subject
Written By
Posted
Re: Rewrite Full Outer Join into Subquery
October 12, 2014 09:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.