|
Subject:
|
SQL - Help with Joins
|
|
Posted By:
|
oldmuttonhead
|
Post Date:
|
1/21/2006 4:02:36 PM
|
Here's my situation:
tblRefs:
RefID
FirstName
...etc.
tblDates:
DateID
DateData
tblSports:
SportID
Sport
tblOffDates:
RefID
DateID
tblOffSports:
RefID
SportID
I need to be able to get a recordset that contains referees who are NOT working on a specific date. For example, Mr. Scheduler asks to find a basketball referee who is open on Feb 1, 2006. How do I get all the refs who do NOT have a record for that date?
Thanks in advance for your help!!
|
|
