SQLite Forum

WHERE a IN (SELECT non-existing column )
Thank you, Richard, Keith and Carl. I did not know about this SQL feature.

I know and agree that fully qualified name is proper use. But it is long to type, more typos and more to edit when applying the same query to a different table/database.