SQL Server 2014.
I'm writing a stored proc. The proc accepts a jobID as input and should return the CandidateID of all persons who qualify for the job. There are two tables involved:
The only thing common between the two tables is the SkillID. So, if I query the JobSkill table and get the following SkillID's:
SELECT SkillID from JobSkill WHERE JobID = 1278
How can I find the candidates in the CandidateSkill table who have those EXACT JobSkills? They have to be a perfect match.