Join type output examples

Select a join type option based on your desired output. Use the examples below to guide your selection.

Inner join

Returns only the records that have matching values in the selected columns in both tables.

For example, if you have a table of employees and their departments, and a table of employees and their pay rates, this option will return a table of the employees that exist in both tables, and their departments and pay rates.

Table 1: Employees and Departments
Employee Department
John 101
Jill 102
Mike 103
Betty 104
Cindy 105
Table 2: Employees and Pay rates
Employee Pay rate
John 50
Betty 50
Mike 40
Jill 35
Dan 45
Table 3: Employees, Departments, and Pay rates
Employee Department Pay rate
John 101 50
Jill 102 35
Mike 103 40
Betty 104 50

Left outer join

Returns all records from the first table, and the matched records from the second table.

Using the example Tables 1 and 2, this option returns the following table:

Table 3: Employees, Departments, and Pay rates
Employee Department Pay rate
John 101 50
Jill 102 35
Mike 103 40
Betty 104 50
Cindy 105

Right outer join

Returns all records from the second table, and the matched records from the first table.

This option returns the following table:

Table 3: Employees, Departments, and Pay rates
Employee Department Pay rate
John 101 50
Betty 104 50
Mike 103 40
Jill 102 35
Dan 45

Full outer join

Returns all records when there is a match in either left or right table.

This option returns the following table:

Table 3: Employees, Departments, and Pay rates
Employee Department Pay rate
John 101 50
Jill 102 35
Mike 103 40
Betty 104 50
Cindy 105
Dan 45