Getting ready

• To follow along with this recipe, you can use the Merge Queries and Append Queries icons on the Home tab of the Query Editor to generate the join expressions used in this recipe
• As joining queries is fundamental to the retrieval process, it's recommended to learn the Table.Join(), Table.NestedJoin(), and Table.Combine() functions