Join data easily

A join creates a data source with columns coming from two (or more) tables. 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 you drag and drop another table next to an existing one in the data source workplace. There is always a left-hand table and a right-hand table. In the following screenshot, you can see a join between Orders (the left-hand table), and People (the right-hand table):

The result of a join is a data source that contains the columns from the different joined 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. We will discover these 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...