Skip to content

Instantly share code, notes, and snippets.

@mpurbo

mpurbo/gist:1030819

Created June 17, 2011 03:34
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 mpurbo/1030819 to your computer and use it in GitHub Desktop.
Save mpurbo/1030819 to your computer and use it in GitHub Desktop.
Download ZIP
Simple many-to-many PostgreSQL query
Raw
gistfile1.sql
SELECT pg.*
FROM programmers pg
WHERE EXISTS(
SELECT pp.programmer_id
FROM programmers_projects pp
WHERE
pp.programmer_id = pg.programmer_id AND
pp.project_id IN (1, 2) -- or whatever condition to filter the projects
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment