Missing data when I create a join

Preparing Data
1

Why am I missing rows of data after I create a join?

2

When you create a join in StarLifter you are actually creating a Left Join. A Left Join will return all records from the left table , combined with any matching records from the right table(s). If there are not any matching rows from the right table they will not be returned.

Here are some videos around Joins:
Part 1 - Creating a Join in StarLifter - Part 1 of 2 - YouTube
Part 2 - Creating a Join in StarLifter - Part 2 of 2 - YouTube