Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Left Anti Semi Join Showplan Operator
Collapse the table of content
Expand the table of content

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.

Community Additions

© 2015 Microsoft