?

Log in

No account? Create an account
patrickwonders
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';