In-line subqueries (derived tables)

Barman Jason schrieb:

Hello all.

I am using Oracle v7.3 and Business Objects v4.1.1 and was wondering if is possible with Business Objects to create an in-line subquery (I believe they are also called derived tables) such as the following without using free hand SQL:

SELECT
z.some_column
,sum(b.some_column)
FROM
(
SELECT
a.some_column
FROM
some_table a
WHERE
a.some_column = some_condition
) z
,another_table b
WHERE
z.some_column = b.some_column
GROUP BY
z.some_column

To my knowledge, this is NOT possible at the moment. What you can do is both “correlated” and “uncorrelated” sub-queries from the query-panel.
Both only in conditions.

Walter.

Walter Muellner
Delphi Software GmbH, Vivenotgasse 48, A-1120 Vienna, Austria Tel. +43-1-8151456-12, Fax: +43-1-8151456-21 e-mail: w.muellner@delphi.at, WEB: http://www.delphi.at


Listserv Archives (BOB member since 2002-06-25)