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

Which of the following types of joins involves joining every row from one table to every row from another table?

24. Which of the following types of joins involves joining every row from one table to every row from another table?

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

Answer: F) CARTESIAN JOIN

Explanation:

CARTESIAN JOIN involves joining every row from one table to every row from another table.