Ajudando o menino Elland

elland.skill.candidate.sql

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