Re: Problem adding a join to a hierarchial query

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@xxxxxxxxxxxxxx> wrote:
> So, is it true that each "root" in PROVIDER_CONTRACT_STATUS table has
> only one leaf?
> 
> 
> 
> Igor Neyman, OCP DBA
> ineyman@xxxxxxxxxxxxxx
--
http://www.freelists.org/webpage/oracle-l

Other related posts: