Left outer join is used to combine all rows from the left table with matching rows from the right table.

• Use the LEFT JOIN keyword to perform a left outer join

• The syntax is: SELECT column_name(s) FROM ...read more