TechNet
Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

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.

Community Additions

ADD
Show:
© 2016 Microsoft