In which of the following situations would one have to use an outer join in order to obtain the desired results?
A) A report is desired that lists all customers who placed an order.
B) A report is desired that lists all customers and the total of their orders.
C) A report is desired that lists all customers, the total of their orders during the most recent month, and includes customers who did not place an order during the month (their total will be zero).
D) There is never a situation that requires only an outer join.

Question

Quizplus · Accepted Answer

Choice C requires an outer join because it requires the inclusion of customers who did not place an order during the most recent month. An inner join would only include customers who did place an order during that time period. Choices A and B can be achieved using inner joins. Choice D is incorrect because there are situations that require outer joins, as demonstrated by Choice C.

In Which of the Following Situations Would One Have to Use