This article explains how to show all table rows when using a query within a query by using SQL for Confluence app.
Instructions
The following query is an example that uses a join and provides data to an outer query. Write the below code in a SQL Query macro and select Output format as Wiki as shown below:
- The output of the above query is as shown below: