Sorry Wayne,
I doubt this can be done in a simple statement. The problem is that you
don't want a join, but something more like a UNION statement and then count
the result. I guess your best option is to write a stored procedure where
you do two selects, add the result and then return the sum and the employee
number if it is less than 8.

If you're lucky maybe someone has a simpler solution for you,
Set