HOTSPOT
You use Advanced Editor in Power Query Editor to edit a query that references two tables named Sales and Commission. A sample of the data in the Sales table is shown in the following table.
A sample of the data in the Commission table is shown in the following table.
You need to merge the tables by using Power Query Editor without losing any rows in the Sales table.
How should you complete the query? To answer, select the appropriate options in the answer are a.
NOTE: Each correct selection is worth one point.
Hot Area:
its LeftOuter, you need to keep all the data of Sales table (which is on the left)
https://learn.microsoft.com/en-us/power-query/merge-queries-left-outer