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?
A . complete join
B . partial join
C . inner join
D . outer join
Answer: D