Re: [sqlite] [EXTERNAL] No such column error

The mailing list is deprecated. You need to go to https://sqlite.org/forum/ for the sqlite forum. Can you replicate the problem while using the sqlite shell? Are you checking column names returned from the second statement? Note that a.BIRTH.YYY from your example looks a bit weird for a

[sqlite] No such column error

I have been developing a c++ program in windows. In this program, in a loop, I open database, query and update the records then close it. I am encountering randomly with "No such column error". Query looks like that (but there are more columns than this STATUS table): "select a.BIRTH_DATE,

[sqlite] Use of same aliases in single query

Hi list, Accidentally I discovered that I could use the same table aliases for 2 tables in a single sql statement. As long as I do not use a column name that exists in both tables Sqlite accepts this. It looks strange to me that I can use the same aliases multiple times, and that they