Which type of JOIN returns only rows where there is a match in both tables?

SQL Fundamentals Easy

SQL Fundamentals — Easy

Which type of JOIN returns only rows where there is a match in both tables?

Key points

INNER JOIN only includes matching rows
LEFT JOIN includes all rows from the left table
RIGHT JOIN includes all rows from the right table
FULL JOIN includes all rows from both tables

Ready to go further?

Start full exam Practice more questions

Related questions