If you do not need to link tables together to obtain the combined data, you can skip this step.
- Select the tables you want to link together.
- Click Create join.
- Under Join, select the option Join or Left Outer Join
Join = Results are only shown when there is a match in both tables. If there is no match, the data will not be shown in the final result.
Left Outer Join = All values from the left table are shown, even if there is no match in the right table. - You will then reach a window where you can link columns from both tables. In both tables, select the column that contains the same data so we can match those.
- Click Add.
- Then click on Close at the bottom left.
- You have now returned to the Join overview. Click Next to proceed.