Left outer join

What is a left outer join?

A left outer join is a join that keeps every row from the first (left-hand) table regardless of whether that row matched any in the second (right-hand) table. Columns from the second table are filled with NULL if there was no match.