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

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

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.