Left Semi Join Showplan Operator

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.

See Also

Tasks

How to: Display an Actual Execution Plan

Concepts

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

Help and Information

Getting SQL Server 2005 Assistance