MikeL7 wrote:
> I have also done the query seperate and used a union all clause and get the
> right results, but the employees are listed twice and the counts are all in the
> same column instead of two different one named after their alias.
>

I can't see using a UNION would , you need to do something like I
suggested, did that not work?

Steve