var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Organisation Chart
I have a Employee Master table named "Employee_Master". This has got the fields like as follows,
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
mgr.employee_name as reporting_manager
from employee_master emp ,employee_master mgr
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..........
This would be exactly what you need.