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...