RIGHT JOIN: RIGHT JOIN is similar to LEFT JOIN. This join returns all the rows of the table on the right side of the join and matching rows for the table on the left side of join. The rows for which there is no matching row on left side, the result-set will contain null. RIGHT JOIN is also known as RIGHT OUTER JOIN.

When use left join and right join?

LEFT JOINRIGHT JOINIt joins two or more tables, returns all records from the left table, and matching rows from the right-hand table.It is used to join two or more tables, returns all records from the right table, and matching rows from the left-hand table.

What is the difference between a join and an outer join operation?

What is the difference between a join and an outer join operation? Explanation: The outer join operation preserves a few tuples that are otherwise lost in the join operation. The outer join operation preserves the tuples to the right of the operation.