SQL Server: JOIN vs IN vs EXISTS - the logical difference (weblogs.sqlteam.com)
submitted by
spirit1(3160) 4 years, 8 months ago
There is a common misconception that IN behaves equaliy to EXISTS or JOIN in terms of returned results.
This is simply not true.
See why not and how to avoid the confusion.
|category: Database
|Views: 234
tags:
EXISTS LogicalDifference DatabaseDesign Join SQL another
Everyones tags:
Your Tags: