Okay, this is kind of weird...
I have a table that keeps track of all of the employees for my company, we'll call it Employees. Within this table is a column for the supervisor for each employee. Since the supervisors themselves are employees, they are also in in the Employees table.
So Joe Smith is a manager, and Jon Doe is a manger underneath Joe. I need to display the employees that work under Jon....and since Joe has more than one manager working under him, I can't just use Jon's information to display his subordinates.
Basically what I'm trying to say is I need to display ALL the "Second Tier" employees under Joe Smith. So the people that work for Jon Doe, etc...
I hope I'm explaining myself clearly enough, if not, let me know and I'll try again...
I have a table that keeps track of all of the employees for my company, we'll call it Employees. Within this table is a column for the supervisor for each employee. Since the supervisors themselves are employees, they are also in in the Employees table.
So Joe Smith is a manager, and Jon Doe is a manger underneath Joe. I need to display the employees that work under Jon....and since Joe has more than one manager working under him, I can't just use Jon's information to display his subordinates.
Basically what I'm trying to say is I need to display ALL the "Second Tier" employees under Joe Smith. So the people that work for Jon Doe, etc...
I hope I'm explaining myself clearly enough, if not, let me know and I'll try again...