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