Subquery here failing:( WHY?!
Say I got a "users" table, with columns as UserID, FirstName, LastName, City. Now, suppose there's just a single record/row in this table, with UserID=1. Then, the following SQL query should give back to us just the list of UserIDs in the table which are not equal to 6, namely UserID equal to just 1. SELECT UserID FROM users WHERE UserID != 6 This definitely gives us back just UserID=1, which is actually the only UserID in the original table anyway. Now, why is it that the following query fails to delete the one and only record in the original table with UserID=1 ??? DELETE FROM users WHERE UserID = (SELECT UserID FROM users WHERE UserID != 6); Just trying to play around tbh and get used to actual practice of SQL queries, subqueries specifically here. BIG THANKS :D for any help :)