MySQL Forums
Forum List  »  Newbie

Re: Making query ONLY_FULL_GROUP_BY compatible
Posted by: Wim Roffel
Date: July 16, 2016 12:14AM

Those name dupes are indeed a problem. In this situation dupes are the rule and differences will be rare.

The only solution I see at the moment is to give the outer query in your example a GROUP BY too (and a MAX(description)). Not a very nice solution. Also, it gives problems when I add more fields: each extra field would mean one more nested query.

Do you know a better solution?

Options: ReplyQuote




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.