SQL Right join returns all records from the right table (table2), and the matched records from the left table (table1). The result is NULL from the left side when there is no match. RIGHT JOIN performs a join starting with the second (right-most) table and then any matching first (left-most) table records.

RIGHT JOIN and RIGHT OUTER JOIN are the same.

SQL Right Join Tutorial With Example

SQL RIGHT JOIN keyword returns all the records from the right table (table2), and the matched records from a left table (table1). The result is NULL from the left side when there is no match. In some databases, the RIGHT JOIN is called RIGHT OUTER JOIN. The RIGHT JOIN clause allows us to  query data from the multiple tables.

#sql #sql right #right join