SQL Left Join

Left Outer Join will select all rows from left table in the joining condition, no matter if these rows from left table have matching records in the right table. Left table is the one that is straight after SQL from Clause.