Left Anti Semi Join

The Left Anti Semi Join logical 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.

See Also

Using Joins

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.