http://www.w3schools.com/sql/sql_join_right.asp

This join returns all the rows from the right table in conjunction with the matching rows from the left table. If there are no columns matching in the left table, it returns NULL values. Example - Select * From Table1 RIGHT Join Table2 ON table1.ColumnName = Table2.ColumnName