How to do Nested Queries

[JPCogAdmin]

Hi,

I was wondering how to do nested queries or "Inline Views".
Through Oracle I've been writing SQL code and then in Framework Mgr. I've put in the code as pass-through.

However, does anyone in this list know how to do or use inline views throught either: FM or Report Studio?

Some of the queries I have go like this:

(Statement A)
select fields.... from tablex where
(I set my criteria here) T

Then I use an outer select to compare values with the previously created select statement (A). In this outer query I know sum specific fields based on the inner query.

So has someone done this before and do you know the steps?
Thanks.
-J

 

[blom0344]

Seems like a overly complicated solution. The neatest solution is to compile the complete SQL into a database-view and use this in FM..

Ties Blom

 

[JPCogAdmin]

Thanks Ties,

That certainly sounds to me like the easier and perhaps best way to go. However, I was still wondering how to do nested/sub queries from exising query subjects?

-J

 

[Nuffsaid]

Hi,

In Report Studio (C8), using Query Explorer, drag a new query to the IMMEDIATE RIGHT of an existing query, a flashing VERTICAL bar will appear. Drop the query when the bar appears. Should be able to figure it out from there...



Nuffsaid.