You can choose join types to link fields in different data sources.
You can create the following types of joins between two tables in a join view:
Inner join creates a result table by combining column values in two tables A and B based on the join condition. Data Validation Option compares each row in A with each row in B to find all pairs of rows that satisfy the join condition.
Left outer join
Left outer join between tables A and B contains all records of the left table A, even if the join condition does not find any matching record in the right table B. The resulting join contains all rows from table A and the rows from table B that match the join condition.
Right outer join
Right outer join between tables A and B contains all records of the right table B, even if the join condition does not find any matching record in the left table A. The resulting join contains all rows from table B and the rows from table A.
Full outer join
A full outer join contains all the rows from tables A and B. The resulting join has null values for every column in the tables that does not have a matching row.