Embedded SQL and Impromptu

[BlueBrand]

A report I'm working on requires an embedded select as displayed below. What I do to use that in Impromptu, is paste the SQL into the query profile window. The downside is that I lose some functionality inherent to Impromptu since I'm limited to the sql statement. Anyone know of another way to do this?

It goes something like:

select A.column1,
B.column1
from table A,
(select ...
where conditions
and not exists (select ...)) B
where conditions

 

[jbecher]

I would create a database view using this SQL you describe and add it to the catalog.

-Justin

 

[angiole]

If this request is a candidate for automation, you could save both result sets to otfiles, and create report 3 to merge the results.