Many-to-many selections query
Đọc bài viết
Cỡ chữ
Table: candidate_skills
candidate_id (PKey)
skill_id (PKey)
Table: skills
skill_id (PKey)
Table: job_skill_required
job_id(PKey)
skill_id(PKey)
select candidate_id
from candidate_skills
where skill_id
in ( select skill_id
from job_skill_required
where job_id = 937 )
group
by candidate_id
having count(*)
= ( select count(*)
from job_skill_required
where job_id = 937 )
from candidate_skills
where skill_id
in ( select skill_id
from job_skill_required
where job_id = 937 )
group
by candidate_id
having count(*)
= ( select count(*)
from job_skill_required
where job_id = 937 )