Export (0) Print
Expand All

Left Anti Semi Join

SQL Server 2000

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

Show:
© 2014 Microsoft