This diagram shows Cross Join type in Spark SQL. It returns the Cartesian product of two tables (relations).
JOIN - Spark 3.2.1 Documentation (apache.org)