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 co-exist.
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, a.BIRT
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 qualifi
3 matches
Mail list logo