Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
The Left Outer Join operator returns each row that satisfies the join of the first (top) input with the second (bottom) input. It also returns any rows from the first input that had no matching rows in the second input. The nonmatching rows in the second input are returned as null values. If no join predicate exists in the Argument column, each row is a matching row.
Left Outer Join is a logical operator.
See Also
Tasks
How to: Display an Actual Execution Plan
Concepts
Using Outer Joins
Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)