Tags: create, creating, database, discoverer, mysql, nested, oracle, query, sheet, sheets, sql, subquery
Discoverer Subquery Help needed
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.
C_Id = A_Id (Subquery sheet A)
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?
Leave a comment...
- 0 Comments