Re: Problem adding a join to a hierarchial query

From: Adam Donahue <adonahue@xxxxxxxxxxx>
To: Adam Donahue <adonahue@xxxxxxxxxxx>
Date: Wed, 17 Nov 2004 13:06:40 -0800

Forgot the table aliases.

Anyhow, I guess I'm misunderstanding the question based on the other 
suggested queries.

Adam

> select
>    p.provider_id,
>    pcs.provider_contract_status_id curr_id,
>    pcs.prev_prod_contract_status_id prev_id,
>    level
> from
>    provider p left join provider_contract_status pcs on 
> p.provider_contract_status_id = pcs.provider_contract_status_id
>    connect by prior pcs.prev_prod_contract_status_id = 
> pcs.provider_contract_status_id
>
> This should work on 9i, no?
>
> Adam
>

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

References:

Problem adding a join to a hierarchial query
From: Mike Spragg

Re: Problem adding a join to a hierarchial query
From: Adam Donahue

Re: Problem adding a join to a hierarchial query

Other related posts: