Hi
I'm having some problem getting the following result.
I have 2 tables
Drivers
--------
DriverID int (PK)
DriverName varchar(50)
Runs
-------
RunID int (PK)
DriverID int (FK)
Speed float
ET float
Example data:
Drivers:
DriverID DriverName
-------------------
1 Nisse
2 Ken
3 Dan
Runs:
RunID DriverID Speed ET
-----------------------------
1 3 143.2 5.99
2 2 33.22 10.39
3 3 139.3 6.34
4 1 213.1 5.23
5 1 211.2 5.32
What i wan't is to get every drivers best ET sorted like this
DriverID DriverName RunID Speed ET
-------------------------------------
1 Nisse 4 213.1 5.23
3 Dan 1 143.2 5.99
2 Ken 2 33.22 10.39
Hope this is possible.
Thanks
Patric