-
In which join all the rows from the left table appear in the output irrespective of the content of the other table?
-
- OUTER JOIN
- RIGHT JOIN
- LEFT JOIN
- INNER JOIN
- None of these
Correct Option: C
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.