Join (SQL)
A right outer join works almost like a left outer join, except with how the tables are handled reversed.  This time, all of the relevant information will be returned from the right table, even if the left table does not have a matching result.  If the left table does not have a matching result, null will be in the place of the missing data.