Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> multilevel hierarchy query

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).

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US