Detailed explanation and options for the selected question.
Which SQL clause is used to combine rows from two or more tables with matching values?
A.
INNER JOIN
B.
FULL JOIN
C.
OUTER JOIN
D.
CROSS JOIN
Explanation:
INNER JOIN combines rows from two or more tables with matching values. FULL JOIN returns all rows, OUTER JOIN includes unmatched rows, and CROSS JOIN returns a Cartesian product.