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 Iowa High School Rodeo Association
iowa high school rodeo association cowboy calendar

join iowa high school rodeo association
ihsra FAQs
 iowa high school rodeo association rodeo schedule
iowa high school rodeo results
 iowa high school rodeo association rodeo standings
ihsra members
 iowa high school rodeo association officers and directors
login
contact  iowa high school rodeo association
ihsra links



 Cowboy Calendar : IHSRA Home :  Rodeo Standings

Form: Grid BoysSeasonStandings_tblMe
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid GirlsOverallStandings_tbl
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid BarebackStandings_tblMemb
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid BarrelRacingStandings_tbl
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid BoysCuttingStandings_tblM
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid BreakawayRopingStandings
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid BullRidingStandings_tblMe
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid CalfRopingStandings_tblMe
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid GirlsCuttingStandings_tbl
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid GoatTyingStandings_tblMem
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid PoleBendingStandings_tblM
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid SaddleBroncStandings_tblM
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid SteerWrestlingStandings_t
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

Form: Grid TeamRopingStandings_tblMe
Error: The Microsoft Jet database engine cannot find the input table or query 'tblMembers'. Make sure it exists and that its name is spelled correctly. (Microsoft JET Database Engine)

 



 

 

 
 
  ©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