Microsoft
98-364 · Question #179
You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column. The results include: - All customers and their orders - Customers who…
The correct answer is D. outer join. See the full explanation below for the reasoning.
Question
You have a Customer table and an Order table. You join the Customer table with the Order table by using the CusromerID column. The results include:
- All customers and their orders
- Customers who have no orders
Which type of join do these results represent?
Options
- Acomplete join
- Bpartial join
- Cinner join
- Douter join
How the community answered
(22 responses)- A18% (4)
- B9% (2)
- C5% (1)
- D68% (15)
Community Discussion
No community discussion yet for this question.