Join queries

Explore how to leverage joins to retrieve data from multiple tables using a related column.

Use joins to combine data from multiple queries based on a related column. Join queries enrich a dataset by bringing related information from another query.

Infobridge supports the following join types:

• Inner join: Returns only records that have matching values in both queries.
• Left join: Returns all records from the base (left) query and matching records from the joined (right) query.
• Right join: Returns all records from the joined (right) query and matching records from the base (left) query.
• Full outer join: Returns all records from both queries, regardless of whether a matching value exists.

Example scenario#

The following example shows regional sales data.

The tax rate for each region is stored in a separate lookup table.

An inner join returns only records that have matching values in both queries. Because LATAM doesn't have a matching rate type, it isn't included in the result.

A left join returns all records from the base query. Rows without matching values remain in the result, and unmatched columns are blank.

Join queries in Infobridge#

This example joins the Sales and COGS query with the Monthly interest rate query by using the Month column.

The Sales and COGS query contains sales and cost data.

The Monthly interest rate query contains the average monthly interest rates.

To create a join query:

1. On the Home ribbon, select Join Query.

2. In the Join Query dialog:

   • Select Sales and COGS as the Base Query.
   • Select Monthly interest rate as the Query To Join.
   • Under Columns, select Month for both queries.
     

   

3. Select the required Join Type:
   • Inner
   • Left Outer
   • Right Outer
   • Full Outer

4. Select Apply.
   

   

   Infobridge creates a new query that combines columns from both queries.

   If the joined query contains duplicate join columns, such as Month and Month_1, remove the duplicate column from the report layout if it isn't required.