JOIN NOW

Informatics Practices

There are multiple ways to create cartesian product of two tables in MySQL. Describe them.

SQL Joins & Grouping

61 Likes

Answer

The two ways to create cartesian product of two tables in MySQL are as follows:

1. Creating Cartesian Product Without Join Condition:

SELECT * 
FROM table1 JOIN table2;

2. Creating Cartesian Product Using CROSS JOIN Clause:

SELECT * 
FROM table1
CROSS JOIN table2;

Answered By

3 Likes

Related Questions