Hopefully someone can shed some light on a problem I'm having
I have 2 tables: "game_sched" and "referees"
The Game_sched consists of several fields which include game_date, start_time, end_time and Referee1, Referee2, and Referee3.
The Referee fields corespond to the id numbers of the Referees in the referee table.
What I'm trying to do is, given a specific date and time, find a list of referees that do not apear in the game_sched for that give date and time.
I have 2 tables: "game_sched" and "referees"
The Game_sched consists of several fields which include game_date, start_time, end_time and Referee1, Referee2, and Referee3.
The Referee fields corespond to the id numbers of the Referees in the referee table.
What I'm trying to do is, given a specific date and time, find a list of referees that do not apear in the game_sched for that give date and time.