I have a table that is a list of users that I need get as a heirachal answer set. This table has people from 1st level, 2nd level, and 3rd level in the organizations heirarchy all built the same way..i.e.
user_id first_name last_name supervisor_id
My problem is that supervisors are built the same way, where the supervisor_id is actually a 2nd line manager. What I need to do is retrieve users by specifying the 3rd level (second line manager) , and list it as such:
Whit the supervisors being built the same as a user, I need to devise a way to make an answer set that lists each user, their boss, and their bosses boss. Is this a problem that a recursive query could handle? My appologies if this is a rudamentary question, I'm still learning as I go.