By tag: in
0
kicks
SQL Server: JOIN vs IN vs EXISTS - the logical difference
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.
0
kicks
You Should Never Use IN In SQL To JOIN With Another Table
Do you use the following syntax?
SELECT *
FROM TABLE
WHERE CoLumn IN (SELECT CoLumn FROM TABLE)
Do NOT use that it can cause big problems if you do not understand exactly how IN and NOT IN works