multilevel hierarchy query

From: Bruce Hensley <nobody_at_nowhere.com>
Date: Tue, 15 Feb 2005 09:56:38 -0800
Message-ID: <cutd6t$hgl$2@domitilla.aioe.org>

I don't know how to begin on a query (SELECT statement) to find all the tasks assigned to an arbitrary manager (say, staffID='JSmith') and her organization, that is, assigned to all her underlings, and their underlings, and .... For that matter, I don't even know how to find everyone in her organization (at all levels).

• All individuals have only one manager
• Tasks are assigned to individuals
• A manager at any level may have direct reports and sub-managers

The table structure:

tblStaff

---

staffID
reportsToID (staffID of direct manager)

tblTasks

---

taskID
assignedToID (staffID of individual responsible for task)

Any help would be greatly appreciated.

Bruce Received on Tue Feb 15 2005 - 11:56:38 CST