D
Don
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
same with the requirements
Order ID SkillId
1 2
1 3
Order has orderdate and duration, the employees have employee availability
startdate, length and enddate.
i have tried to do two queries, one to find out which employee is availablr
for which order and the second to find out which employee has the expertise
to do another. then i could do a join of the two.
this is resulting very difficult in both cases, please can anbody help or
provide suggestions of different ways.
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
same with the requirements
Order ID SkillId
1 2
1 3
Order has orderdate and duration, the employees have employee availability
startdate, length and enddate.
i have tried to do two queries, one to find out which employee is availablr
for which order and the second to find out which employee has the expertise
to do another. then i could do a join of the two.
this is resulting very difficult in both cases, please can anbody help or
provide suggestions of different ways.