$ ./guess_the_languageSQL & Databases
SQL & Databases · easy · #8

Which join keeps every row of the left table, even when nothing matches on the right?

  1. LEFT JOIN
  2. CROSS JOIN
  3. RIGHT JOIN
  4. INNER JOIN
A LEFT JOIN returns all left rows and fills the right-side columns with NULL when there is no match.
Play SQL & Databases ▸