Overview

It is now possible to create Multi-Table Joins between tables in BarTender Cloud. Multi-Table Joins combine records from two tables whenever there are matching values in a field common to both tables.

Applicable to

BarTender Cloud

Information

Multi-Table Joins are available for SAP HANA, Azure SQL, and Oracle database connection types: 

After selecting any one of these database connection types you will be asked to enter your connection details. Once the connection is established, you will need to complete the below steps in order to perform a table join: 

1. Before getting started, you will be prompted to choose between letting the assistant generate the SQL statement (Recommended) and providing the SQL statement yourself. Select the first option as shown below.

2. Click Next to continue.
3. Choose 2 or more tables that you would like to join by double-clicking the tables in the list on the left. The selected tables will appear in the list on the right. If you want to undo a selection, double-click the table in the right list. 

4. Click Next to continue.
5. If you selected 2 or more tables you will be prompted to specify a join clause. If you selected more than 2 tables, you will need to specify an additional join clause for each additional table.

5. 1. You can select from the following options for the Join Type with Inner Join as the default option. 
      
   2. You can select from the following options for the Operator with equals as the default option.
      
   3. Below the Join clause you have 3 buttons. 
      
      
      1. Preview allows you to preview the resulting dataset for a completed join clause. 
      2. Auto Join attempts to select the fields for each table automatically in order to generate a join clause. 
      3. Clear resets the join clause to its default values. 
6. Click Next to complete specifying the join clause and complete the subsequent steps of the Template Assistant. 

Additional Resources

Configuring a Database Connection Using BarTender Cloud