Inner Join Showplan Operator

The Inner Join logical operator returns each row that satisfies the join of the first (top) input with the second (bottom) input.

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

Using Inner Joins

Displaying Execution Plans by Using the Showplan SET Options (Transact-SQL)