Join data easily

A Join creates a single Data Source with columns coming from two (or more) tables. How do Joins work? How can you create them? Are there risks? You'll learn everything in this section.

The Join principle

So far, we've only used one table. A Join is automatically created when using two or more tables. There is always a left table and a right table. In the following screenshot, you see a Join between Orders (the left table), and People (the right table):

The result of a Join is a Data Source that contains the columns from the different tables. As highlighted in the screenshot, you can see that the Profit column comes from the Orders table, and the Person column comes from the People table:

There are four different types of join. Discover them in the next section.

Join requirements and types

To create a Join between two tables, you need at least one column in each table that contains the same values. These common columns create the link between the two tables. When you create a Join...