right join

SELECT *
FROM table_1
RIGHT JOIN table_2
ON table_1.common_field = table_2.common_field;

-- Left Join
SELECT column_name(s)

FROM table1

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

Matching part from both table and unmatching part from left table.

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