Informatics Practices
There are multiple ways to create cartesian product of two tables in MySQL. Describe them.
SQL Joins & Grouping
3 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
2 Likes