Important Points About CROSS JOIN
- CROSS JOIN performs the cross-product of records from two or more joined tables.
- It is used when we want every possible combination of rows to be present in a database’s tables.
- SQL CROSS JOIN with condition of WHERE Clause operates as an INNER JOIN; when used without one, it produces the cartesian product of all the rows from all the tables provided in the SQL query.
- CROSS JOIN is different from other join types like INNER JOIN, LEFT JOIN, and RIGHT JOIN, as it does not require a matching condition between the tables.
Related Links
SQL CROSS JOIN
SQL CROSS JOIN returns all the records from the left and right tables. CROSS JOIN returns a combination of each row in the left table paired with each row in the right table.