Which JOIN type returns only rows with matching values in both tables?

SQL Data Analyst Easy

SQL Data Analyst — Easy

Which JOIN type returns only rows with matching values in both tables?

Key points

  • INNER JOIN filters out non-matching rows
  • LEFT JOIN includes all rows from the left table
  • RIGHT JOIN includes all rows from the right table
  • FULL OUTER JOIN includes all rows from both tables

Ready to go further?

Start full exam Practice more questions

Related questions