Get Ready to Learn SQL Server: 14. Introduction to Outer Joins - CodeProject

It is of interest to note that there are actually two kinds of left outer joins. The kind that includes the records from the right table and the kind that excludes records from the right table. A good illustration of this can be found on stack overflow: L

www.codeproject.com