Results 1 to 2 of 2
  1. #1
    Join Date
    May 2004
    Location
    bangalore
    Posts
    270

    Unanswered: 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

  2. #2
    Join Date
    Nov 2005
    Posts
    122
    This would be exactly what you need.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •