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/