Re: Problem adding a join to a hierarchial query

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