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!
"not exists" question
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
Check out JOINS (there's an example in there of what you want to do):
http://www.mysql.com/doc/en/JOIN.html
Mac
http://www.mysql.com/doc/en/JOIN.html
Mac