Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: nesting select statments

Re: nesting select statments

From: Umar FArooq <umar.farooq_at_cressoft.com.pk>
Date: Wed, 10 Jun 1998 17:01:59 +0500
Message-ID: <357E75B6.F10A8094@cressoft.com.pk>


Yes it is possible... the foll stmt would work select * from tab1 a, (select * from tab2) b where a.pk=b.fk

Bruce Woodward wrote:

> Hi,
>
> Is it possible to nest select statments? eg
> select something, something, something, (select something from
> something)
> from something
>
> thanks in advance,
> Bruce
Received on Wed Jun 10 1998 - 07:01:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US