Hi all -

I have the following tables:

Riders - names of riders, country, sex

Teams - team names, year active

Horses - name of horses, gender, color, passport #

Results - jumping results rider, horse used, team name, etc.

Team Membership - team name, year active, rider name

Results is linked to Riders, Teams, and Horses.

Team Membership is linked to Riders and Teams.

I can gather team/rider results using the team membership table. But am unsure how to go about getting results by team, then by Rider, then by horse.

Thanks,