Combined Query in a sub-select

building reports desktopintelligence
1

Can you produce a combined query within a sub-select with Business Objects 4.1? I would like to use the MINUS operator within a sub-query. It seems as if the combined query button is disabled when working on a sub-query. Is this always a true statement or is this something we can override? I have not been able to find a way to override this. I have been able to produce a query using the except operator in a sub-query, but it does not accomplish exactly what I want to do. Is there another way to use a temporary result set with Business Objects (as opposed to using a sub-query)?

Thanks,
Peter Borjestedt g

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

2

So, you want to do something like this:

SELECT T1.A
FROM T1
WHERE T1.A IN
( SELECT T2.A FROM T2
MINUS
SELECT T3.A FROM T3 )

You realize this could be accomplished like this:

SELECT T1.A
FROM T1
WHERE T1.A IN
( SELECT T2.A FROM T2 )
AND T1.A NOT IN
( SELECT T3.A FROM T3 )

And then you don’t need a combined sub-query.

Erich Hurst
Compaq Computer Corporation
(281) 514-9445
Erich.Hurst@Compaq.com

Can you produce a combined query within a sub-select with Business Objects 4.1? I would like to use the MINUS operator within a sub-query.

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