Patrick (patrickwonders) wrote,
Patrick
patrickwonders

  • Mood:

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';
Subscribe
  • Post a new comment

    Error

    default userpic

    Your reply will be screened

  • 2 comments