SQL Server: JOIN vs IN vs EXISTS - the logical difference (weblogs.sqlteam.com)
submitted by
spirit1(3160) 5 years 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: 238
tags:
EXISTS LogicalDifference DatabaseDesign Join SQL another
Everyones tags:
Your Tags: