in that case you’re good to go
Thanks for helping out again - its always good to learn by working though things like this.
So MAX will pick out the max value from a group, and if using a GROUP BY clause, it needs all the fields from the select list. (Even if mySQL lets it slide, its good practice regardless.)
Which I can see makes sense - if you’re telling it to group records, it would like to know the order of the grouping for all of the fields in the select list, rather than just the first and be expected to guess the rest.
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.