Merging queries: right join

Your manager is interested in evaluating salespeople that have had more than one order per customer in a particular region. To assist with this process, a table of orders per region was assembled so you can combine with your existing sales data. A right join is perfect for this situation as it allows you to only join the relevant data for your analysis.

If you lost any progress, load the workbook 2_3_right_join.pbix from the Exercises folder on the Desktop.