Home » MCQs » Transact-SQL (T-SQL) MCQs

Which of the following types of joins selects all the rows from the right table if there are no matches found in the left table?

23. Which of the following types of joins selects all the rows from the right table if there are no matches found in the left table?

1. INNER JOIN
2. LEFT JOIN
3. RIGHT JOIN
4. FULL JOIN
5. SELF JOIN
6. CARTESIAN JOIN

Answer: C) RIGHT JOIN

Explanation:

RIGHT JOIN is a type of join which selects all the rows from the right table if there are no matches found in the left table.