I am trying to do a query which will return the three fastest atheletes, with their associated records.
I have done the following
SELECT TOP 3 r.result, c.Nationality, c.First_Name, c.Last_Name
FROM tblResults r inner join tblCompetitor c on r.competitor_id=c.ID
inner join tblEvent e on r.event_id=e.ID
inner join tblRound ro on r.round_id=ro.ID
WHERE e.Event_Name = '100M Run' and
ro.Round_Number = 'Round_1'
ORDER BY r.result
it says i am missing an operator on the inner joins. What am i doing wrong?