Re: GROUP BY, MIN() row ordering problems!

[Gavin Lovegrove]

Hi Max,

Just for your interest ... I received this query back from another forum which also works ... I have a little trouble understanding it, but it works too!

Gavin

SELECT r.resultID
, a.athleteID
, r.event
, t1.raceTime
, r.placing
, r.competition
, r.`date`
from results r
inner join athletes a
on r.athleteID = a.athleteID
inner join (
select athleteID, min(raceTime) as raceTime
from results
group by athleteID
) t1
on a.athleteID = t1.athleteID
and r.raceTime = t1.raceTime
order by raceTime