This diagram shows Inner Join type in Spark SQL. It returns rows that have matching values in both tables (relations).
JOIN - Spark 3.2.1 Documentation (apache.org)