Roger Pullen wrote:

> 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.

'IN SET' ?
I emulate it by using a integer to represent up to 32 yes/no reasons,
and match the correct number. The reasons table has 32 entries, and this
provides names against the flags.
BIGINT would allow 64 flags.
Or multiple INT's for groups of skills.
Best way I found of selection visits for reason X,Y and Z only.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services