Re: multilevel hierarchy query

Rauf,

Thanks! Excellent!!

This is perfect for my Oracle data.

Now I need to do the same in Access 97 tables. I can't find anything similar
to CONNECT BY for Access 97.

Bruce

Rauf Sarwar wrote:
> Bruce Hensley wrote:
> > 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
>
> You can find information about hierarchical queries at
>

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/queries4a.htm#2053937
>
> URL may wrap.
>
> Regards
> /Rauf
Received on Tue Feb 15 2005 - 13:25:30 CST