Simple OUTER JOIN : LEFT OUTER JOIN « Table Join « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Table Join
  3. LEFT OUTER JOIN
The first syntax situation is the easy part - most people get this part just fine.

SELECT <SELECT list>
FROM <the table you want to be the "LEFT" table>
<LEFT|RIGHT> [OUTER] JOIN <table you want to be the "RIGHT" table>
                       ON <join condition>








4.5.LEFT OUTER JOIN
4.5.1.Simple OUTER JOIN
4.5.2.The query uses non-ANSI outer join operators (*= or =*)
4.5.3.Employees and Their Managers
4.5.4.Selecting titles that have not been sold.
4.5.5.LEFT OUTER JOIN with condition