Syntax of Cartesian Join

How to Perform Cartesian Join on Tables?

With the WHERE clause

SELECT *
FROM table 1 
CROSS JOIN  table 2
WHERE condition

`Without the WHERE Clause`

SELECT table1.column1 , table2.column2...
FROM table1, table2...
CROSS JOIN table2;

Cartesian Join

In SQL, a Cartesian Join is also called a Cross Join, it performs the cartesian product of records of two or more joined tables. A Cartesian product matches each row of one table to every other row of another table, only when the WHERE condition is not specified in the query. In case the WHERE condition is specified then the Cartesian Join works as an Inner Join.

Tags:

#SQL-Clauses #SQL

How to Perform Cartesian Join on Tables?

Syntax of Cartesian Join

With the WHERE clause

Without the WHERE Clause

Cartesian Join

Similar Reads

`Without the WHERE Clause`