Re: Problem adding a join to a hierarchial query

From: Mike Spragg <meltedpat_at_gmail.com>
Date: Wed, 17 Nov 2004 11:25:31 -0600
Message-ID: <7f89e3750411170925119f2cde@mail.gmail.com>

Thanks everybody for the help!

By tweaking your suggestions I have come up with the following:

select p.provider_id, pc.provider_contract_status_id, pc.prev_prov_contract_status_id
 from (select provider_contract_status_id curr_id,

          prev_prov_contract_status_id prev_id
          from provider_contract_status

start with provider_contract_status_id in (select provider_contract_status_id from provider) connect by prior prev_prov_contract_status_id = provider_contract_status_id) pc, provider p where p.provider_contract_status_id (+) = pc.provider_contract_status_id;

provider_id    curr_id          prev_id
323232        87944200     87825800
                   87825800
000001        87332200
006400        88249600    88173600
                   88173600    88169600
                   88169600

Is there any way to get the following result where the provider_id is populated on every row?

provider_id    curr_id          prev_id 
323232         87944200     87825800
323232         87825800
000001         87332200
006400         88249600    88173600
006400         88173600    88169600
006400         88169600

Thanks again - Mike

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

Received on Wed Nov 17 2004 - 11:53:53 CST