Skip to content

Instantly share code, notes, and snippets.

@Tocacar

Tocacar/gist:2412688

Created April 18, 2012 10:28
Show Gist options
  • Save Tocacar/2412688 to your computer and use it in GitHub Desktop.
Save Tocacar/2412688 to your computer and use it in GitHub Desktop.
Download ZIP
SQL query
Raw
gistfile1.txt
SELECT
p.id
FROM
project_licence p
INNER JOIN
lab l
ON
p.lab_id = l.id
RIGHT OUTER JOIN
lab_user lu
ON
lu.lab_id = l.id
WHERE
lu.user_id = 63
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment