SELECT * FROM Teams, Divisions WHERE Teams.DivisionID = Divisions.DivisionID AND Teams.DivisionID = #URL.DivisionID# ORDER BY Teams.AssociationID SELECT PointsSummary.TotalLosses AS Losses, PointsSummary.TotalTies AS Ties, PointsSummary.TotalWins AS Wins, PointsSummary.TotalGames AS Games, PointsSummary.TotalPoints AS Points, Divisions.DivisionName AS Division, Teams.TeamName AS Team, Teams.TeamID AS TeamID FROM (PointsSummary INNER JOIN Divisions ON PointsSummary.DivisionID = Divisions.DivisionID) INNER JOIN Teams ON PointsSummary.TeamID = Teams.TeamID WHERE ((PointsSummary.DivisionID) = #URL.DivisionID#) ORDER BY PointsSummary.DivisionID ASC, PointsSummary.TotalPoints DESC; Augusta Minor Softball - Coaches
#DivisionName#

#DivisionName# Schedule

#DivisionName# Scores

Tournaments

Rules

Teams
Team Name Coach Name Phone Email
Standings
Team Name Losses Ties Wins Games Played Points