right and left join code example

Example 1: right join

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

Example 2: left join

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