CROSS JOIN and JOIN are similar to __________ A. INNER JOIN B.

cross-join-and-join-are-similar-to-a-inner-join-b

CROSS JOIN and JOIN are similar to __________

A. INNER JOIN

B. NATURAL JOIN

C. OUTER JOIN

D. CARTESIAN JOIN

I had been asked this question by my school principal while I was bunking the class.

This key question is from Performing Multiple in portion Using SQL to Manage Data of MySQL

Right answer is A. INNER JOIN

The best I can explain: 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.