SQL question

From: <sumera.shaozab_at_lmco.com>
Date: Tue, 26 Sep 2000 17:52:43 GMT
Message-ID: <8qqnp7$5n0$1@nnrp1.deja.com>

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

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 26 2000 - 12:52:43 CDT