Question 530
A fulfillment report excludes rows lacking a matching warehouse record. Which join applies?
Explanation
Correct Answer
The scenario calls for inner-join match requirement: INNER JOIN retains matching row pairs according to a join condition.
Incorrect Answers
LEFT OUTER JOIN preserves every left-row even when no right match exists, rather than satisfying inner-join match requirement.
CROSS JOIN forms the Cartesian product of both input sets, rather than satisfying inner-join match requirement.
FULL OUTER JOIN retains unmatched records from both sides as well as matching rows, rather than satisfying inner-join match requirement.