Manage a Query's Relationships

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:

1. In the query, select the Relationships tab.
2. From the Sources left panel, drag the corresponding columns from each source to under Relationships. 
   
3. 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

4. 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.