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






  1. SQL Server / T-SQL Tutorial
  2. Table Join
  3. LEFT OUTER JOIN
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