In the example images below is the reference to Service Desk solution tickets table, therefore, we seek the selected ID in Query 2 (secondary), do not exist in Query 1 Primary.
|1. In Query 1 run your selection|
|2. Create a second Query 2 and run your selection|
CA BI Sub Query 01
3. Select the "Off the list"
CA BI Sub Query 02
4. Select the "Result from another query"
CA BI Sub Query 03
5. Select the query and the desired column in the example there is only one Query.
CA BI Sub Query 04
6. Result after run
CA BI Sub Query 05
7. Final: result: The report
CA Bussiness Intelligence: Subquery - Português
CABI4::. Summary - BOXI for CA SDM