MySQL Forums
Forum List  »  General

Re: Null records create vastly different results
Posted by: Peter Brawley
Date: April 05, 2022 10:42AM

Your data determines your result, and we can't see it. To understand the subqueries, run them by themselves.

The subqueries do not aggregate. ...Group By id2... entails that the subquery will return one row per id2 value. What do you hope this Group By clause will accomplish?

Options: ReplyQuote


Subject
Written By
Posted
Re: Null records create vastly different results
April 05, 2022 10:42AM


Sorry, only registered users may post in this forum.

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.