Which of the following is not outer join?
A) LEFT JOIN
B) RIGHT JOIN
C) INNER JOIN
D) FULL OUTER JOIN
Answer:
C) INNER JOIN
Explanation:
INNER JOIN is not an outer join; it’s a type of join that returns only the rows with matching values in both tables being joined. In contrast, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN are types of outer joins that include rows with unmatched values from one or both tables.
