LEFT OUTER JOIN


LEFT OUTER JOIN - always contains all rows of the "left" table (A), even if the join-condition does not find any matching row in the "right" table.