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, click Add Relationship .
- 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