Hi All,
Suppose employee table consists fields like empno, empname, designation, reportingid {which consists of empno whom he is reporting}.
if this table contains employees of team member, team lead, project mngr, group lead, m.d.
i need a query which populates the data when a team member id is given as input. the result should be team member name, empno, reportingid, reportingname, again reporting reportingid, name and his reporting id,name etc...
eg:-
Team Member Name, Team Member No, his reporting name & no, again his reporting name & no, again his reporting name & no, etc.
Regards,
Rajendra Prasad