use where in left join code example

Example: left join

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