SQLite Forum

WHERE a IN (SELECT non-existing column )
This is, however, a common case where standard SQL behavior can be very surprising and puzzling.  I remember the first time this happened to me, and it took me a while to find my bug.  (The problem was buried in a substantial amount of code.)  Some people advocate always qualifying all column names for this reason.  No, I don’t do that.