Left Semi Join Showplan Operator
SQL Server 2008 R2
The Left Semi Join operator returns each row from the first (top) input when there is a matching row in the second (bottom) input. If no join predicate exists in the Argument column, each row is a matching row.
Left Semi Join is a logical operator.