J
JP SIngh
Hi All
I am in a very tricky situation wonder if you anyone can help.
We have a table where we store employee information. One of the fields in
the table stores the manager number which is the employee number of the
users manager. Sample data is below
EmpNo Name ManagerNo
2211 Peter 9900
8899 James 9900
9900 Mel 9111
9901 Ian 9111
9111 Simon 9111
I want to able to display all the employees who report to a certain manager
and also all the employees who report to them
Something like
Simon
Ian
Mel
Peter
James
I am sure this can be done but I don't know how to do it recursively. Can
help guys?
I am in a very tricky situation wonder if you anyone can help.
We have a table where we store employee information. One of the fields in
the table stores the manager number which is the employee number of the
users manager. Sample data is below
EmpNo Name ManagerNo
2211 Peter 9900
8899 James 9900
9900 Mel 9111
9901 Ian 9111
9111 Simon 9111
I want to able to display all the employees who report to a certain manager
and also all the employees who report to them
Something like
Simon
Ian
Mel
Peter
James
I am sure this can be done but I don't know how to do it recursively. Can
help guys?