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)