Hello,
I have business problem where I need to match a large list of candidates with a large list of job roles with a variety of qualifications. For example:
This table defines the qualifications for each role:
Role Requirement Requirement Group Manager M1 1 Manager M2 1 Manager M3 2 Manager M4 3 Engineer E1 1 Engineer E2 2 Engineer E3 2 Accountant A1 1 Accountant A2 1
The table shows the applicants and their qualifications:
Name Qualification Ryan A2 Renee E1 Renee E2 Steph M1 Jason M1 Jason
JasonM3
M4Mike E2
Note that an applicant must meet at least one requirement from each requirement group. So to be a manager the applicant must have ((M1 OR M2) AND M3 AND M4) I would like to be able to query this data to get the following results:
Role Name Qualification Manager Jason M1 Manager Jason M3 Manager Jason M4 Engineer Renee E1 Engineer Renee E2 Accountant Ryan A2
I have full control over the tables, but my challenge is finding a way to query "a candidate that has at least one of each requirement from each requirement group for one role".
Any help would by much appreciated!