Page 1 of 1

"not exists" question

Posted: Sat Feb 08, 2003 10:33 pm
by tennis_blues
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!

Posted: Mon Feb 10, 2003 2:50 am
by twigletmac
Check out JOINS (there's an example in there of what you want to do):
http://www.mysql.com/doc/en/JOIN.html

Mac