what is a right join code example

Example 1: right join

RIGHT JOIN: Matching part from both
table and unmatching part from right table.

Example 2: RIGHT JOIN Syntax

SELECT column_name(s)

FROM table1

RIGHT JOIN table2
 ON table1.column_name = table2.column_name;