Re: Discoverer 3.1: Subqueries

Hi have you tried this

a sheet for the lowest subquery (only include linking column) a 2nd sheet for the middle subquery linked in a condition to the lowest subquery (only include linking column)
a 3rd sheet for the parent query linked in a condition to the middle subquery.

when you run the parent the subqueries should resolve themselves from the bottom up.

in the conditions say

'a' IN [select New Subquery]

in wizard select existing sheet and match the linking columns if above is used (ie only column in subquery) will automatically match

Hope this helps
Mark Gornicki
<noellewalter_at_my-deja.com> wrote in message news:89juql$6ir$1_at_nnrp1.deja.com...
> Can anyone tell me how to have multiple subqueries in Oracle Discoverer
> 3.1? I need to have parent query -> subquery -> subquery, and I can't
> seem to get it to work. When I go to create the parent query, the
> second level subquery is not an option in the create subquery section
> of my conditions. This is the way I believe I need to go, since I
> can't seem to simulate an "and exists" clause in any other way. Any
> ideas would be greatly appreciated.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Mar 11 2000 - 00:51:42 CET