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