left join , right join code example Example: right join RIGHT JOIN: Matching part from both table and unmatching part from right table.