MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: mysql sums not working correctly with joins
Posted by: Rick James
Date: April 25, 2016 06:41PM

I don't see the SUM() call.

Keep in mind that JOIN inflates the number of rows, then GROUP BY deflates them. But meanwhile, the inflated set of rows is being COUNTed, SUMmed, etc.

Navigate: Previous Message• Next Message
Options: Reply• Quote




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.