By tag: EXISTS
Ban this user: Options
Please provide a reason for deleting this story
Simple yet very underused way to check if rows matching a condition exist.
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.