Hi,
Select person from persons as p, person_skills as ps
where p.personid = ps.person_id
And ps.skill_id in (id1,id2..);
Anvar.
At 09:40 PM 21/01/2002 -0500, you wrote:
>I have three tables as follows (simplified):
>
>persons (person_id,person)
>skills( skill_id,skill)
>person_skills( person_
I have three tables as follows (simplified):
persons (person_id,person)
skills( skill_id,skill)
person_skills( person_id,skill_id)
A person can have one or more entries in the person_skills table, indicating
their skills.
I need to select persons where there skills match ALL skill_id's in a set
