If you include multiple sources in a query, add relationships to define how to combine, or join, their records.
Defining a Source Relationship
To create a relationship between two sources, specify which of their columns share common data and how to join their records:
- In the query, select the Relationships tab.
- From the Sources left panel, drag the corresponding columns from each source to under Relationships.
- Select how to join the sources' records.
Join Returns Left Join All records from the left source, and any also matched in the right source Right Join All records from the right source, and any also matched in the left source Inner Join Only records matched in both sources Full Join All records from either source
Sorting a Query's Relationships
After you add a query's relationships, you can sort them in the order they should occur, such as if one depends on another's join. To adjust a relationship's position in the order, select Move up or Move down from its menu.
Removing a Relationship
To delete a relationship from a query, such as if you no longer use its sources, select Remove from its menu.