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
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
