what is left join with null code example

Example: left join

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