Which situation would most benefit from an outer join?

An outer join includes unmatched rows from one or both tables, filling in missing values for the table with no match. Choice D needs every customer to appear, even when there is no matching order, which is the purpose of a left outer join. Choices A and C describe returning only matching rows, which an inner join does.

AI-written and checked against the verified answer.