why use a right join in sql code example Example: right join RIGHT JOIN: Matching part from both table and unmatching part from right table.