SELECT TOP 10 BoysSeasonStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM BoysSeasonStandings INNER JOIN tblMembers ON BoysSeasonStandings.idContestent = tblMembers.idContestent ORDER BY SumOfintTotal descSELECT TOP 10 GirlsOverallStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM GirlsOverallStandings INNER JOIN tblMembers ON GirlsOverallStandings.idContestent = tblMembers.idContestent ORDER BY SumOfintTotal descSELECT TOP 10 BarebackStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM BarebackStandings INNER JOIN tblMembers ON BarebackStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 BarrelRacingStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM BarrelRacingStandings INNER JOIN tblMembers ON BarrelRacingStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 BoysCuttingStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM BoysCuttingStandings INNER JOIN tblMembers ON BoysCuttingStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 BreakawayRopingStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM BreakawayRopingStandings INNER JOIN tblMembers ON BreakawayRopingStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 BullRidingStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM BullRidingStandings INNER JOIN tblMembers ON BullRidingStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 CalfRopingStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM CalfRopingStandings INNER JOIN tblMembers ON CalfRopingStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 GirlsCuttingStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM GirlsCuttingStandings INNER JOIN tblMembers ON GirlsCuttingStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 GoatTyingStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM GoatTyingStandings INNER JOIN tblMembers ON GoatTyingStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 PoleBendingStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM PoleBendingStandings INNER JOIN tblMembers ON PoleBendingStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 SaddleBroncStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM SaddleBroncStandings INNER JOIN tblMembers ON SaddleBroncStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 SteerWrestlingStandings.*, [IA#], GradYear, LASTNAME, FIRSTNAME FROM SteerWrestlingStandings INNER JOIN tblMembers ON SteerWrestlingStandings.idContestent = tblMembers.idContestent ORDER BY SumOfPoints descSELECT TOP 10 TeamRopingStandings.*, tblMembers.[IA#] AS [tblMembers_IA#], tblMembers.GradYear AS tblMembers_GradYear, tblMembers.LASTNAME AS tblMembers_LASTNAME, tblMembers.FIRSTNAME AS tblMembers_FIRSTNAME, tblMembers1.[IA#] AS [tblMembers1_IA#], tblMembers1.GradYear AS tblMembers1_GradYear, tblMembers1.LASTNAME AS tblMembers1_LASTNAME, tblMembers1.FIRSTNAME AS tblMembers1_FIRSTNAME FROM (TeamRopingStandings INNER JOIN tblMembers ON TeamRopingStandings.idContestentHeader = tblMembers.idContestent) INNER JOIN tblMembers tblMembers1 ON TeamRopingStandings.idContestentHeeler = tblMembers1.idContestent ORDER BY SumOfPoints desc
![]() |
![]() |
|||||||
|
![]() ![]() ![]() |
|||||||
| ©2003 Iowa High School Rodeo Association All Rights Reserved |
Home | Join IHSRA | FAQs | Rodeo
Schedule | Results | Standings | Members Officers and Directors | Login | Contact Us | Links | Photo Gallery |
|||||||