_____ is used to retrieve records that do not meet the join condition
Answer options
A
Outer join
B
Inner join
C
Self join
D
Cross join
Correct answer: Outer join
Explanation
Outer joins return rows that do not satisfy the join condition (unmatched rows).