Skip to content

Instantly share code, notes, and snippets.

@amitaibu

amitaibu/gist:7b460474ba5f6a04fb8e0921d4b0234d

Created August 13, 2016 18:31
Show Gist options
  • Save amitaibu/7b460474ba5f6a04fb8e0921d4b0234d to your computer and use it in GitHub Desktop.
Save amitaibu/7b460474ba5f6a04fb8e0921d4b0234d to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
SELECT *
FROM company
LEFT OUTER JOIN group_membership
ON (company.id = group_membership.company_id AND group_membership.user_id=1)
WHERE group_membership.company_id IS NULL
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment