"not exists" question
Posted: Sat Feb 08, 2003 10:33 pm
this may be an easy question....and i am just too tired too think?? but can you please help?
i would like to run a query that gets all the days where there is no meeting scheduled
so my tables are:
Table 1 (Day) - DayID (filled with Tuesdays for the next year)
Table 2 (Meeting) - MeetingID, DayID, ContactName, Time
so what is the query that gets all the DayID where there isnt a Meeting.DayID = Day.DayID
please help!
thanks!
i would like to run a query that gets all the days where there is no meeting scheduled
so my tables are:
Table 1 (Day) - DayID (filled with Tuesdays for the next year)
Table 2 (Meeting) - MeetingID, DayID, ContactName, Time
so what is the query that gets all the DayID where there isnt a Meeting.DayID = Day.DayID
please help!
thanks!