[kapetang]

Σάκη, δοκίμασε μήπως δουλέψει:

SELECT TOP 3 t.ID_RACE, t.RACE, t.ID_CONT, t.NAMES, t.GR_NAT, t.NATION, t.CATEGORY, t.SCORE1
FROM DAY1_SCORE_PCP AS t
WHERE (((t.SCORE1) In (SELECT TOP 3 SCORE1
FROM DAY1_SCORE_PCP
WHERE
ID_RACE=t.ID_RACE and
NATION=t.NATION
ORDER BY SCORE1 DESC, ID_CONT
)))
ORDER BY t.SCORE1 DESC, t.ID_CONT