8.1. CROSS JOIN
- The CROSS JOIN produced a result set which is the product of rows of two associated tables when no WHERE clause is used with CROSS JOIN.
- In this join, the result set appeared by multiplying each row of the first table with all rows in the second table if no condition introduced with CROSS JOIN.
- This kind of result is called as Cartesian Product.
- The CROSS JOIN behaves like JOIN and INNER JOIN without using any condition.
- In standard SQL the difference between INNER JOIN and CROSS JOIN is ON clause can be used with INNER JOIN on the other hand ON clause can't be used with CROSS JOIN.
QUERY: - SELECT * FROM t1, t2 WHERE condition;
EXAMPLE: - SELECT * FROM employee, salary;
Last modified: Monday, 2 December 2019, 12:19 PM