Question

The left and right joins are also known as __________

(a) INNER JOIN

(b) NATURAL JOIN

(c) OUTER JOIN

(d) CARTESIAN JOIN

This question was addressed to me in class test.

I'm obligated to ask this question of Performing Multiple topic in portion Using SQL to Manage Data of MySQL

Answer 1

Correct answer is (c) OUTER JOIN

Best explanation: The ‘inner join’ only deals with rows where a match can be found in both tables. The ‘LEFT JOIN’ and ‘RIGHT JOIN’ types are ‘OUTER JOIN’ types which differ from inner joins in this sense.