Re: Problem adding a join to a hierarchial query

From: Mike Spragg <meltedpat_at_gmail.com>
Date: Wed, 17 Nov 2004 13:42:31 -0600
Message-ID: <7f89e37504111711423594c40a@mail.gmail.com>

No - Each "root" in the PROVIDER_CONTRACT_STATUS table can have 0 to many "leafs".

I think the problem I have is that only the current provider_contract_status_id (or "root") has a tie back to get the provider_id from the PROVIDER table. What I am trying to do is apply that associated provider_id to all the "leafs" that I get from the "root". I can tie it to the "root" but all "leafs" have a NULL provider_id.

Hope that makes some sense.

On Wed, 17 Nov 2004 14:33:24 -0500, Igor Neyman <ineyman_at_perceptron.com> wrote:
> So, is it true that each "root" in PROVIDER_CONTRACT_STATUS table has
> only one leaf?
>
>
>
> Igor Neyman, OCP DBA
> ineyman_at_perceptron.com

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Nov 17 2004 - 13:45:48 CST