RIGHT OUTER JOIN « Table Joins « SQL Server / T-SQL






1.RIGHT OUTER JOIN includes all the information from the table on the right
2.RIGHT OUTER JOIN with 'not NULL' condition