Skip to content

Instantly share code, notes, and snippets.

@enricostano

enricostano/gist:182f0bbb03ec4581e925

Created September 9, 2014 23:45
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save enricostano/182f0bbb03ec4581e925 to your computer and use it in GitHub Desktop.
Save enricostano/182f0bbb03ec4581e925 to your computer and use it in GitHub Desktop.
Download ZIP
Queries
Raw
gistfile1.sql
SELECT users.id FROM users WHERE users.id IN (SELECT m2.user_id FROM memberships AS m1 INNER JOIN memberships AS m2 ON (m1.user_id = 3 AND m2.group_id = m1.group_id));
SELECT users.id FROM users INNER JOIN memberships AS m1 ON (users.id = m1.user_id) INNER JOIN memberships AS m2 ON (m1.group_id = m2.group_id) WHERE m2.user_id = 3;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment