MySQL Forums
Forum List  »  Newbie

Re: Rewrite Full Outer Join into Subquery
Posted by: Richard House
Date: October 14, 2014 11:29AM

Thanks for your reply.

These are big tables thus I did not provide the create tables in full (Actuals ..id's are indexed, Projection's are as well but not auto) but if you particularly need them to set up a solution for me I'll gladly provide them.

Suppose, all those suggestions are sorted out, can the query be written as subquery or as RIGHT..UNION DISTINCT..LEFT as you suggested and how?

Thanks Rick!

Options: ReplyQuote


Subject
Written By
Posted
Re: Rewrite Full Outer Join into Subquery
October 14, 2014 11:29AM


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.