SQL query syntax help Hi. I'm stumped and came here for help. After poking around I realize
you guys know way more than me. Still, a little help would be much
appreciated.
I've got a table with columns ClassNumber, TheDate, RaceNumber,
StudentID, RaceSpeed.
There are race results for this year's classes. My goal is to create a
report / query that shows the race winner for each race in the table.
My plan was to do this by selecting the identifying information using a
Min(RaceSpeed).
The problem I'm facing is that I'm not sure how to setup this "group" or
even if it is possible. A unique race is made up of the fields
ClassNumber, TheDate, and RaceNumber so I would need to group on
multiple fields to make it happen.
Is this possible?
Perhaps I setup the table incorrectly that would make this type of
select impossible. I really have no idea.
Please help.
Thank you.
-Scott |