Question · SQL and MySQL course · Module 7: Joining tables (JOIN)

What LEFT JOIN returns

What will a LEFT JOIN of tables A and B (A LEFT JOIN B) return?

Answer options

  • All rows from table A plus matched rows from B; when there is no match, the columns from B are NULL
  • Only the rows that match in both tables
  • All rows from table B, and only matched rows from A
  • Only the rows that have no match

You can check the correct answer by solving this task in the CodeWorlds game.