Check out example codes for "use left outer join in sql". It will help you in understanding the concepts better.

Code Example 1

SELECT table1.column1, table2.column2...
FROM table1
LEFT JOIN table2
ON table1.common_field = table2.common_field;

Code Example 2

left join or left outer join

Learn ReactJs, React Native from akashmittal.com