Left join will keep all data from the left table but will not bring data from the right table if it's not in the left table. Union is the same as an outer join meaning it brings all data points (null/non-null) from both tables. In terms of visualization: Union will combine both data into one column while a left join will partition the data into separate columns