Home » MCQs » MySQL MCQs

Which type of join combines the result from both the tables and returns us the Cartesian product of the values?

49. Which type of join combines the result from both the tables and returns us the Cartesian product of the values?

1. Right join
2. Left join
3. Inner join
4. Cross join

Answer: D) Cross join

Explanation:

CROSS JOIN combines all the data from the first table and the second table. The result obtained through this join is the Cartesian product like every value will be multiplied with every other value of another table.