Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: nesting select statments
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