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

Which of the following joins returns rows when there is a match in the tables?

22. Which of the following joins returns rows when there is a match in the tables?

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

Answer: A) INNER JOIN

Explanation:

INNER JOIN is a type of join that returns the rows as a result when there is a match in the tables.