Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Ajudando o menino Elland
SELECT
jb.*
FROM
jobs jb
INNER JOIN jobs_skills jbs
ON jbs.job_id = jb.id
INNER JOIN skills skj
ON skj.id = jbs.skill_id
LEFT JOIN (
candidates cn
INNER JOIN candidates_skills cns
ON cns.candidate_id = cn.id
INNER JOIN skills skc
ON skc.id = cns.skill_id
)
ON skc.id = skj.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment