Joining Multiple Tables in Reports

Kloudio provides an option to add join conditions for multiple tables. Please follow the below steps to join two tables

Step 1: Create a Report by following steps:

1. Navigate to the Reports page and click on

2. Select the connection you created earlier.

3. Choose the schema/database name where your data resides.

4. Pick your table from the results

5. Select all or individual columns in the report by clicking on the column name.

Step 2: Select the other table to join:

1. Now select the matching columns for which you need to create the Join conditions

2. Select the required columns for the table you need to join

3. Now join popup will be visible. Select any one of the following four join types:

   1. Inner Join

   2. Outer Join

   3. Left Join

   4. Right Join

Step 3: Select the columns from the two tables and the required Join condition and once join condition is selected, click OK then all the respective joined tables will be visible

Step 4: Now you can see the preview after joining the tables, Save the Join tables with required name.

Congratulations! You have successfully joined multiple tables in Reports with Kloudio.