Very basic:
select pa.role
from PROCEED pr, PART pa
where pr.last_timestamp < sysdate
and pr.number0 = pa.number0;
--
Frank
<sumera.shaozab_at_lmco.com> schreef in berichtnieuws
8qqnp7$5n0$1_at_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
>
> SS
>
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Sep 28 2000 - 01:48:04 CDT
