Ales, thanx...ur code helped me get the results i wanted.
However, i then added in the WHERE clause:
and e.emp_type in (1,2)
This little statement undid what was achieved with the in-line view. It's back to square 1 now.
Why would adding that statement cause this problem and how to overcome it?

Thanx in advance
Peace,
Sakitah