Which join kind should you use?

Posted by: Pdfprep Category: 70-778 Tags: , ,

You have two tables named Customer and Orders.

A sample of the Data in Customer is shown in the following table.

A sample of the data in Orders is shown in the following table.

You need to create the following new table.

You must use Customer as the first table.

Which join kind should you use?
A . Right Anti
B . Right Outer
C . Left Anti
D . Left Outer
E . Inner

Answer: D

Leave a Reply

Your email address will not be published.