Hello,

I have been using the LearnITfirst videos on TSQL 2008 programming, Querying and more recently SSRS. I recommend them as they are quite detailed compared to others I have come...

You are using a right join which is only counting employees that belong to each type.

I suspect you are trying to list all employee types irrespective of whether there are...