Hi Alexandre,

> Have you tried this kind of query ?

> where
> and R.SWINTIME = (select min(SWINTIME) from t_RESULT where

T_ATHLETID = A.T_ATHLETID)

> order by
> R.SWIMTIME

If I understand that correctly, only the absolute fastest time of a
ATHLETE is read. Now the fastest time depends on different other
fields:
T_EVENT.STYLEID, T_SESSION.COURSE, T_SESSION.STARTDATE

so I don't think, that this will give correct results.

cu Christian