Using combined queries
Combined queries are a form of advanced querying technique that uses several queries for comparison in order to return a single dataset.
Using combined queries enables us to retrieve results from more than one query into a single table by comparing the rows of each query while a subquery compares a single object result.
Combined queries can use the following operators:
- Union: This will include the rows from both queries (this is also the default operator and is similar to the OR operator between query filters)
- Intersection: This includes the rows that are common to both queries (just like the AND operator between query filters)
- Minus: This includes the rows from the first query minus the rows from the second query
When building ...
Get SAP BusinessObjects Reporting Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
