Spark SQL Joins - Left Outer Join

This diagram shows Left Join type in Spark SQL. It returns all values from the left relation and the matched values from the right relation, or appends NULL if there is no match. It is also called left outer join.

References

JOIN - Spark 3.2.1 Documentation (apache.org)