Re: How to select the latest record from a joined table base on certain field?

[Felix Geerinckx]

Anthony Wong wrote:

> and I want to select the the Player information from Player table and just its latest (base of
> Score_Date) Score information from Player_Score table.
> ...
> However, the above queries cannot correctly return the Player_Score.Score value in the same
> record with the max Score_Date for that Player_No.
>
> The Score value returned seem to be the first Score value from the set of record in the same
> Player_no.

See http://dev.mysql.com/doc/mysql/en/group-by-hidden-fields.html

--
felix
Please use BBCode to format your messages in this forum.