Outer Join

A join between tables where the order in which the tables are searched does affect the result.

Also see Inner Join