Left Anti Semi Join

[Andrey Krivda 232973226]

Hi!
Whether there is an example where is used "Left Anti Semi Join"?

andrey@tic.com. ua

[Anith Sen]

Re: Left Anti Semi Join

This is a internal logical operator which comes into play returns each row
from the first table/view/query without a matching row in the second one.
There is no explicit T-SQL equivalent that is applicable 'externally' in a
SELECT statement.

--
- Anith
( Please reply to newsgroups only )

[otisblue]

There is no explicit T-SQL equivalent that is applicable 'externally' in a
SELECT statement.

You're correct that it's an internal logical operation, so one can't be entirely sure when it will be used. But for practical purposes it generally occurs if and only if you use a NOT EXISTS correlated subquery (or correlated NOT IN).