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

    When you submit the form an invisible reCAPTCHA check will be performed.
    You must follow the Privacy Policy and Google Terms of use.
  • 2 comments