I have two sets of queries. A client query that lists the client and their skills (a client can have several lines as the skill comes from a child table where the client is in the parent table). I have a job query, that lists employers and the skills that they are looking for (employer = parent, skills = child, similar to the above).
What would be the best way of finding a match on these two sets of query records, but favouring the job, to find those clients that match the job skill criteria?
e.g. one job may have 3 or 5 or 7 skill entries and I would look for a complete match on those requirements, but a client have many more skills than that and would be suitable if they satisfy the criteria 3/5/7 criteria as set by the employer, whatever that may be.
I could probably do this in VBA but wanted to see if there is a simpler and more elegant SQL solution.
Thanks
What would be the best way of finding a match on these two sets of query records, but favouring the job, to find those clients that match the job skill criteria?
e.g. one job may have 3 or 5 or 7 skill entries and I would look for a complete match on those requirements, but a client have many more skills than that and would be suitable if they satisfy the criteria 3/5/7 criteria as set by the employer, whatever that may be.
I could probably do this in VBA but wanted to see if there is a simpler and more elegant SQL solution.
Thanks