December 2019
Beginner
370 pages
8h 9m
English
The four basic SQL join types are all supported by Tableau: inner, left, right, and full outer. Prior to joining data, you must verify that the data types from the common field used in the join are the same:
| Type of join | Description | Venn diagram of join |
| Inner join | The result set includes all records that have a matching value in both tables. For the Global Superstore Orders 2016 example, this will return all records from the Orders table for which there is a matching person in the People table. | |
| Left join | The result set includes all records from the left table (Orders) and matching records from the People table. For records ... |
Read now
Unlock full access