Another T SQL question please!
I have a table QualificationProfile which is used to define which qualifications are required for a specific profile. So for example it contains the columns
Where PROFILE_ID links to the PROFILE table and QUALIFICATION_ID links to a qualifications table.
I also have a PersonnelQualification table which links a person to their qualification using the following fields
My Question is - How can I get a list of People who match a specific Profile? I.e. they have all of the qualifications defined by a specific profile?