Description: The LEFT JOIN (also called LEFT OUTER JOIN) keyword returns all rows from the left table (table_name1), even if there are no matches in the right table (table_name2).
The result of a left outer join (or simply left join) for table A and B always contains all records of the "left" table (A), even if the join-condition does not find any matching record in the "right" table (B). This means that if the ON clause matches 0 (zero) records in B, the join will still return a row in the result—but with NULL in each column from B. This means that a left outer join returns all the values from the left table, plus matched values from the right table (or NULL in case of no matching join predicate).
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 07th, 2009
SELECT column_name(s)FROM table_name1
LEFT JOIN table_name2
-- orSELECT*FROM employee LEFT OUTER JOIN department
ON employee.DepartmentID = department.DepartmentID
-- for example:SELECT Person.LastName, Person.FirstName, Sales.OrderNo
LEFT JOIN Sales
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.