Hi - tricky SQL - consider a pair of tables in a 1>M relationship:

master table VACANCY with it's own unique ID and a SKILLS
table recording variable number of skills per vacancy.

Question I have is the SQL to extract the Vacancies
for a user-defined number of skills.

ie - user wants all vacancies with SKILL1, SKILL4 and SKILL8
in - just these 3, no more, no less.

Have been experimenting wit correlated queries and
even temporary table, something I am desperate to avoid
if possible but not quite cracked it.

Regards

Roger Pullen