SQL in Oracle Reports 2.5

From: Zeneca <michael.o'neill_at_phwilm.zeneca.com>
Date: 1998/04/17
Message-ID: <01bd6a3d$6ddb9ba0$cc83469c_at_WUSUWPHDEV8L15P.usuwphdev.zeneca.com>#1/1


[Quoted] Does anyone know if it is possible to have nested sub-queries in the 'from' clause of a SQL query in Oracle Reports 2.5.

ex.
select a , b , c from (select a,b from (select rownum a from A where rownum <5) ,B) ,C

This works fine in SQL+ and I beleive that it conforms to ASCII entry level standards Received on Fri Apr 17 1998 - 00:00:00 CEST

Original text of this message