Home » MYSQL » Using Join » Question
  1. In which join all the rows from the left table appear in the output irrespective of the content of the other table?
    1. OUTER JOIN
    2. RIGHT JOIN
    3. LEFT JOIN
    4. INNER JOIN
    5. 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.



Your comments will be displayed only after manual approval.