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.