MySQL Forums
Forum List  »  General

Re: Left join in subquery producing strange results
Posted by: Graham Tilson
Date: February 19, 2014 05:39PM

As I said, this is a cut down version of the query with some values hard coded to try and debug it. Clear the left join in the subquery is superfluous as the fields in the joined table are not being used in the cut down version. However removing this superfluous left join should not affect the query in any way should it?

Options: ReplyQuote


Subject
Written By
Posted
Re: Left join in subquery producing strange results
February 19, 2014 05:39PM


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.