MySQL Forums
Forum List  »  Newbie

Re: Rewrite Full Outer Join into Subquery
Posted by: Richard House
Date: October 12, 2014 09:03AM

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

Options: ReplyQuote


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.