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