Which JOIN type returns all rows from the right table and matched rows from the left table?

SQL Fundamentals Easy

SQL Fundamentals — Easy

Key points

RIGHT JOIN includes all rows from the right table
It only includes matching rows from the left table
LEFT JOIN would return all rows from the left table and only matching rows from the right table

Ready to go further?

Start full exam Practice more questions