Question

What are CROSS JOIN and JOIN are similar to?

(a) INNER JOIN

(b) NATURAL JOIN

(c) OUTER JOIN

(d) CARTESIAN JOIN

I have been asked this question by my college director while I was bunking the class.

My question comes from Controlling How the Server Listens for Connections topic in division General MySQL Administration of MySQL

Answer 1

Correct answer is (a) INNER JOIN

Easiest explanation: The joins ‘CROSS JOIN’ and ‘JOIN’ types are exactly similar to the ‘INNER JOIN’. The statements containing ‘INNER JOIN’ can replace it with ‘CROSS JOIN’ or ‘JOIN’ to get exactly the same result.