PrepAway - Latest Free Exam Questions & Answers

Which type of join will display all customers who have no recorded address?

You have two data sets. One data set contains customer name and age information along with a customer ID. The second data set contains the customer ID along with address information. There are no addresses which do not belong to a customer, there are customers which have no address, and there are customers which have multiple addresses.

Which type of join will display all customers who have no recorded address?

A.Inner join
B.Outer join

C.Partial outer join

D.Anti-join


Leave a Reply