Which join keeps all rows from the left table even if no match exists on the right?
Practice this question from Quiz: DBMS Revision Sheet, with options and an explanation.
Question
Which join keeps all rows from the left table even if no match exists on the right?
Option A
INNER JOIN
Option B — Correct answer
LEFT JOIN
Option C
CROSS JOIN
Option D
SELF JOIN only