Which join kind should you use?

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

You have two queries named client and invoice. A sample of Client is shown in the following table.

A sample of Invoices is shown in the following table.

You need to create a new table that has the following information.

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

Answer: B

Explanation:

https://www.excelguru.ca/blog/2015/12/16/merge-tables-using-outer-join s-in-power-query/

Leave a Reply

Your email address will not be published.