Organisation Chart

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.........

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