Re: SQL question

You can try this :

 Solution 1:

  select role name, name
  from PART
  where fk_proceednumber0 in (select number0

                              from PROCEED
                              where last_timestamp < sysdate);

 Solution 2:

  select role name, name
  from PART p, proceed d
  where p.fk_proceednumber0 = d.number0
  and d.last_timestamp < sysdate;

In article <8qqnp7$5n0$1_at_nnrp1.deja.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.
>

--
Regards
Rajagopal Venkataramany


Sent via Deja.com http://www.deja.com/
Before you buy.