Hi

I need alternative solution to INLINE SQL query.
For example:

select d.deptid, d.deptname,
( select count(empid) from emp e where e.deptid=d.deptid )
from dept d


The solution can be a nested query or any other alternative preferably without cursors.

Thanks
Srinivas