This article explains how how to show all table rows when using a query within a query by using nested query with the SQL for Confluence app.
Instructions
...
For this purpose, the inner query must use a join such that it provides data to
...
the outer query.
...
The query given here is an example; thus, use relevant fields and tables to get the required details from your database.
- Log into your Confluence instance, and create or edit a page.
- Enter {sql and select the SQL Query macro, or, search for the macro name and select it.
- Edit the macro, and, select Output format as Wiki and enter the following code:
The output of the above query is as
...
follows: