Skip to content

Instantly share code, notes, and snippets.

@kalupa

kalupa/gist:1346310

Created November 7, 2011 21:51
Show Gist options
  • Save kalupa/1346310 to your computer and use it in GitHub Desktop.
Save kalupa/1346310 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1
SELECT `essential_exceptions`.reason, `courses`.name FROM `essential_exceptions`
LEFT JOIN `essentials` on `essentials`.id = `essential_exceptions`.essential_id
LEFT JOIN `courses` on `courses`.id = `essentials`.course_id
WHERE `essential_exceptions`.`user_id` = 29966
ORDER BY courses.name;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment