A left outer join, sometimes simply referred to as a left join, is a type of join operation in relational databases. It combines rows from two tables based on a related column, and includes all rows from the left table (first table mentioned in the SQL query) regardless of whether there is a matching row in the right table. Here’s how it works: