Full Outer Join Showplan Operator

The Full Outer Join logical operator returns each row satisfying the join predicate from the first (top) input joined with each row from the second (bottom) input. It also returns rows from:

  • The first input that had no matches in the second input.
  • The second input that had no matches in the first input.

The input that does not contain the matching values is returned as a null value.

Full 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)

Help and Information

Getting SQL Server 2005 Assistance