February 18th, 2005

patrickwonders

Whoa....

I have never used outer joins before. Whoa....

All of the meetings for chapter 1 with no minutes recorded yet:

SELECT Meeting.* FROM Meeting
	LEFT OUTER JOIN Minutes ON Minutes.meetingId = Meeting.id
	WHERE Minutes.id IS NULL AND Meeting.chapterId = '1';
  • Current Mood
    geeky geeky