Match the term with its description.

Outer join

Left join

Returns all records from the

first table, and the matched

records from the second table

Returns records that have

matching values in both tables

Returns all records from the

second table, and the matched

records from the first table