Discoverer Subquery Help needed

Hi everyone,

I have a problem creating a nested subquery in Discoverer 4.

I want to create three sheets: A, B and C. Sheet A is a query on the database, retrieving all Id's that meet a certain condition. Sheet B needs to referr to sheet A and query the database for those Id's from A that meet another set of conditions. Its not possible to create a condition that combines the two, because it would require two loops over the database.

Now, here is the problem: sheet C needs to referr to the results of both sheets A and B to find a certain result in the database.

The problem is that Discoverer doesn't allow me to referr to two different subqueries in the same condition.

For example:

C_Id = A_Id (Subquery sheet A)

AND

C=Id <> B_Id (Subquery sheet B)

Does anyone know how to create those three sheets and make sheet C able to referr to both sheets A and B as a subquery?

http://oracle.itags.org/q_oracle_61644.html