Question

In which join all the rows from the left table appear in the output irrespective of the content of the other table?

(a) RIGHT JOIN

(b) LEFT JOIN

(c) INNER JOIN

(d) OUTER JOIN

I have been asked this question in class test.

The origin of the question is Performing Multiple in portion Using SQL to Manage Data of MySQL

Answer 1

Correct choice is (b) LEFT JOIN

Best explanation: In a ‘LEFT JOIN’, the output is produced for every row of the left table, even if it does not exist in the right table. This is the reason it is called a ‘LEFT JOIN’. ‘LEFT JOIN’ is a kind of OUTER JOIN.