Hi folks,
I have a Employee Master table named "Employee_Master". This has got the fields like as follows,

Employee_ID
Employee_Name
Reporting_To


Now I need a query that can help me to build up the organisation chart. I have a query that gives me some data......... Its like

select emp.employee_id,emp.employee_name,
mgr.employee_name as reporting_manager
from employee_master emp ,employee_master mgr
where emp.reporting_to=mgr.employee_id

But the problem with this query is, it gives only 1:1 mapping. And my requirement is to build a tree structure in ASP Page with the correct query.........

So please help me oput in this regard........


Please lemme know if the problem is not understood to ya guys.......


Waiting for the earliest reply..........


Thanks,
Rahul Jha