Left Anti Semi Join Showplan Operator
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

Left Anti Semi Join Showplan Operator

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

Left Anti Semi Join is a logical operator.

Show:
© 2016 Microsoft