SELECT * FROM Teams, Associations, Divisions WHERE Teams.AssociationID = Associations.AssociationID AND Teams.DivisionID = Divisions.DivisionID AND Teams.AssociationID = #URL.AssociationID# ORDER BY Teams.DivisionID Augusta Minor Softball - Coaches SELECT * FROM Associations WHERE Associations.AssociationID = #URL.AssociationID#
#Association#
Teams
Division Team Name Coach Name Phone Email
#DivisionName#
#TeamName#
#CoachName1#
#CoachName2#
#CoachPhone1#
#CoachPhone2#
#CoachEmail1#
#CoachEmail2#
For more information about #Association# Softball contact:
#RepresentativeName1#
#RepresentativeName2#
#RepresentativeName3#
#RepresentativePhone1#
#RepresentativePhone2#
#RepresentativePhone3#
#RepresentativeEmail1#
#RepresentativeEmail2#
#RepresentativeEmail3#