Re: SELECT grouping problem with MAX()

[Lyle Hopkins]

Hi,
Thanks for the help.

After more than 3 hours of searching, and now minus a lot of hair, I finally found the solution.

SELECT pl.username, amount, pl1.date FROM paylist pl1 JOIN ( SELECT username, MAX( date ) AS date FROM paylist pl2 GROUP BY username ) AS pl2 ON pl1.username = pl2.username AND pl1.date = pl2.date

I've found it to be a lot quicker than the left join

If you ask me it should match up the rows by default. Either way, hopefully this'll save someone else from a lot of stress.