AnsweredAssumed Answered

Brain teaser???

Question asked by fred@kca-inc.com on Feb 8, 2012
Latest reply on Feb 10, 2012 by fred@kca-inc.com

Title

Brain teaser???

Post

I have a Users table which contains all of the normal user information including a unique user_id as well as a "reports_to" user ID (another user in the same table).  The idea is to provide organizational hierarchy to any depth.  The problem I'm having is extracting all of the direct and sub-reports to a user (direct reports, reports to the direct reports, etc.).  I designed it this way to allow any number of levels in an organization.  Any ideas out there on how to extract all of the direct and indirect reports for any user in the table?

Outcomes