Re: SQL question

From: Zbigniew Sliwa <zibi_at_at_yahoo.com>
Date: Wed, 27 Sep 2000 08:36:02 +0200
Message-ID: <39D19552.A4355B69@yahoo.com>

Hi,

That's easy. You can do it in such way:

select role, name from PARTY where fk_proceednumber0 in (select number0 from PROCEED where last_timestamp < sysdate);

-- 
Regards,

Zbigniew Sliwa
Oracle Programmer
Poland
email: zibi_at_at_yahoo.com

sumera.shaozab_at_lmco.com wrote:


> 

> Hello,

> 

> I need some help in trying to combine the following two sql statements

> into one statement:

> 

> select number0,type from PROCEED where last_timestamp < sysdate;

> 

> select role name from PART where fk_proceednumber0 = number0;

> 

> The number0 from the second statement is derived from the first

> statment. So for every number0 derived from PROCEED, I will need to get

> the role and name from PARTY.

> 

> I am not sure how link the two together to make one statment.

> I am trying to query this from oracle database.

> Any help is appreciated.

> 

> Thanks

> 

> SS

> 

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Wed Sep 27 2000 - 01:36:02 CDT