SQL question

Hello,

[Quoted] [Quoted] I need some help in trying to combine the following two sql statements [Quoted] 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 [Quoted] 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 Tue Sep 26 2000 - 19:52:43 CEST