SELECT Games2003.GameNo, Games2003.Field AS FieldID, Games2003.Date, Games2003.Time, Games2003.HomeTeam AS HomeTeamID, Games2003.VisitorTeam AS VisitorTeamID, Fields.Field AS FIELD, Teams.TeamName AS Home, Teams_1.TeamName AS Visitor, Divisions.DivisionName AS Division, Divisions.DivisionID AS DivisionID, Umpires2.ID AS Ump2id, Umpires1.ID AS Ump1id , Umpires2.FirstName AS Ump2First, Umpires2.LastName AS Ump2Last, Umpires1.FirstName AS Ump1First, Umpires1.LastName AS Ump1Last FROM ((Fields INNER JOIN (Divisions INNER JOIN ((Games2003 INNER JOIN Teams ON Games2003.HomeTeam = Teams.TeamID) INNER JOIN Teams AS Teams_1 ON Games2003.VisitorTeam = Teams_1.TeamID) ON Divisions.DivisionID = Teams.DivisionID) ON Fields.FieldID = Games2003.Field) left JOIN Umpires AS Umpires1 ON Games2003.Umpire1 = Umpires1.ID) left JOIN Umpires AS Umpires2 ON Games2003.Umpire2 = Umpires2.ID WHERE (0) = (0) and(((Teams.DivisionID)=#URL.DivisionID#)) OR(((Teams_1.DivisionID)=#URL.DivisionID#)) and Games2003.VisitorTeam = #URL.TeamID# OR Games2003.HomeTeam = #URL.TeamID# and Games2003.Field = #URL.FieldID# and Games2003.GameNo < 2000 ORDER BY Games2003.Date,Games2003.Time ; Augusta Minor Softball - Schedule
SELECT Divisions.DivisionID, Divisions.DivisionName AS DivisionName FROM Divisions WHERE (((Divisions.DivisionID)=#DivisionID#));

#DivisionName# 2018 "DRAFT" Schedule

SELECT Divisions.DivisionName AS Division, Teams.TeamName AS Team, Teams.TeamID FROM Divisions INNER JOIN Teams ON Divisions.DivisionID = Teams.DivisionID WHERE (((Teams.TeamID)=#URL.TeamID#));

2018 #Team# #Division# DRAFT Schedule

SELECT Fields.Field AS Field, Fields.FieldID FROM Fields WHERE (((Fields.FieldID)=#URL.FieldID#));

2017 #Field# - Field Schedule

Game #
Date
Time
Day
Field
Home Team
Visitor Team
Division
Umpire 1
Umpire 2
#scores.GameNo#
#DateFormat(scores.Date,'mm/dd/yy')#
#TimeFormat(scores.Time, "h:mm")#
#DateFormat(scores.Date,'ddd')#