Left Outer Join

This logical operator returns all the records from left hand side table and similar records from right hand side table.

Example: Lets have data as below :-

Now use Left Outer Join (we can use as Left Join also) and have a look at returned result set as below :-