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