How to show all table rows using a nested query with SQL for Confluence

This article explains how to show all table rows using a 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.

1. Log into your Confluence instance, and create or edit a page.
2. Enter {sql and select the SQL Query macro, or, search for the macro name and select it. 
3. Edit the macro, and, select Output format as Wiki and enter the following code:

   

The output of the above query is as follows: