when to use left join and right join code example Example: left join Matching part from both table and unmatching part from left table.