MySQL Forums
Forum List  »  Newbie

Re: Syntax for UPDATING a table with result of an Aggregate (GROUP BY) Inner Join Function
Posted by: Peter Brawley
Date: November 01, 2017 03:25PM

Just what I said: as soon as a value that went into the aggregate calculation changes, the aggregate itself becomes incorrect and misleading, so it's best to put such aggregations in a View or another table.

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.