First of all, We need two tables for more understanding about Joining in SQL; In below there are two tables name mentioned:
LEFT_TABLE (as Table 1)
RIGHT_TABLE (as Table 2).
LEFT OUTER JOIN IN SQL
Left Outer Join is also known as the Left Join; The Left Outer Join returns all records in the LEFT_TABLE (Table 1) and all the matching records from RIGHT_TABLE (Table 2) in a Database.