left join right code example

Example: right join

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