What does a LEFT JOIN return that an INNER JOIN does not?

SQL Data Analyst Easy

SQL Data Analyst — Easy

What does a LEFT JOIN return that an INNER JOIN does not?

Key points

  • LEFT JOIN includes all rows from the left table
  • Unmatched rows from the right table are represented as NULL
  • Useful for analyzing data relationships across tables

Ready to go further?

Start full exam Practice more questions

Related questions