select RecordID, StartDate, EndDate, StartTime, EndTime, Title, Location, 0 as team_id, 0 as game_status from Calendar where (StartDate >= ###today### and StartDate <= ###last_display###) or (StartDate <= ###today### and EndDate >= ###today###) UNION select RecordID, StartDate, EndDate, StartTime, '', team_level+' '+team_name, Location, TeamGames.team_id, game_status from TeamGames, Teams where TeamGames.team_id = Teams.team_id and ((Opponent1 = 'DBCS') or (Opponent2 = 'DBCS')) and ((StartDate >= ###today### and StartDate <= ###last_display###) or (StartDate <= ###today### and EndDate >= ###today###)) order by StartDate, StartTime

Nothing on the calendar

#DateFormat(StartDate, application.GSHORTDTFRM)# -#DateFormat(EndDate, application.GSHORTDTFRM)# (#TimeFormat(StartTime, application.GLONGTMFRM)# -#TimeFormat(EndTime, application.GLONGTMFRM)#)
#Title# Tournament CANCELLED @ select location_id, location, street_address, city_st_zip, directions from TeamLocations where location = '#Location#' ", "ALL"))#')"> #Location#