RIGHT JOIN

The right table will include all its records, left table records will only be included that match with ON. If no match is found on the right table then all the columns related to the left table will be null.

SELECT *
FROM SchemaName.LeftTable AS LeftTable  
	-- RIGHT OUTER JOIN  SchemaName.RightTable AS RightTable -- note outer can be omitted
	RIGHT JOIN  SchemaName.RightTable AS RightTable
	ON LeftTable.colName = RightTable.colName