Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Problem adding a join to a hierarchial query

Re: Problem adding a join to a hierarchial query

From: Adam Donahue <adonahue_at_opsware.com>
Date: Wed, 17 Nov 2004 13:06:40 -0800
Message-ID: <419BBD60.8050600@opsware.com>


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
Received on Wed Nov 17 2004 - 15:10:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US