On 5/26/2014 10:09 AM, Staffan Tylen wrote:
What I want to happen here is that the values in column A1 ('AA1' in this
case) be returned
You can't do that. SQL allows you to manipulate values, but not names.
All table and column names are set in stone when the query is prepared
and the execution plan is determined.
You are effectively doing " select 'A1' from TAB1; " which of course is
very different from " select A1 from TAB1; "
--
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
