By tag: in
Ban this user: Options
Please provide a reason for deleting this story
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.
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