left join with and condition code example

Example: left join

Matching part from both table and unmatching part from left table.