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?
- INNER JOIN
- LEFT JOIN
- RIGHT JOIN
- FULL JOIN
- SELF JOIN
- 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.