Finding the right employee

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have employees that can have up to three different expertise and orders
that can also have three different requirements. all requirements and
expertise are stored on individual fields eg if employee has 2 expertise, it
is stored as follows: -

employee id SkillId
1 1
1 2
2 1
2 2
2 3
same with the requirements

Order ID SkillId
1 1
1 2
1 3
2 1
2 2

in the above case only employee 2 can do order 1 but both employee 1 and 2
can carry out order 2

How can i find out which employee can do which order ? Please can some one
help ?
 
I have tried this, this brings up 71 records. this query retrieves evryone,
eg if order 1 requires skill ID 1, 2 and 3, the query will retrieve all
people that have have skill id 1, skill id 2 and skill id 3.

i need it to retrieve only the employees that have all three.

maybe the above query could be used, somehow ?

thanks for the response.
 
Back
Top