SQL RIGHT JOIN

The SQL Server Right Join returns all the records present in the Right table and matches rows from the Left table. The SQL Server Right join can also call Right outer Join. So, it is optional to use the Outer Keyword. Remember, All the Unmatched rows from the Left table will fill with NULL Values. … Read more