[kapetang]

Καλημέρα

Σάκη δοκίμασε και το:

SELECT 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.ID_CONT) In (SELECT TOP 3 ID_CONT
FROM DAY1_SCORE_PCP
WHERE
ID_RACE=t.ID_RACE and
NATION=t.NATION
ORDER BY SCORE1 DESC, ID_CONT;
)))