Joins

Question 1

Left Join

Answer 1

A table that contains all values from the left table (primary) and corresponding matches from the right table.
When a value in the left table doesn’t have a corresponding match in the right table, you see a null value in the data grid.

Question 2

Inner Join

Answer 2

When you use an inner join to combine tables, the result is a table that contains values that have matches in both tables.

Question 3

Outer Join

Answer 3

A table that contains all values from both tables.

When a value from either table doesn’t have a match with the other table, you see a null value in the data grid.