If you include multiple sources in a query, add relationships to define how to combine, or join, their records.
Define 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 type Returns Left Join All records from the left source, and any also matched in the right source
Note: To avoid duplicates, ensure the column on the right-hand side of a left join contains unique values.
Right Join All records from the right source, and any also matched in the left source
Note: To avoid duplicates, ensure the column on the left-hand side of a right join contains unique values.
Inner Join Only records matched in both sources Full Join All records from either source
- Click Save .
Sort 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.
Remove a Relationship
To delete a relationship from a query, such as if you no longer use its sources, select Remove from its menu.