On 21 Apr 2014, at 6:16am, Andre <andreest...@gmail.com> wrote: > Apparently when a CTE is used, the column name includes the table alias. > However, when no CTE is used, the alias is not present in the returned > column name.
SQLite has no standards at all about column names unless you specifically set a column name using "AS" in your SELECT. If you don't use "AS" then SQLite can return all sorts of weird things as the column names, even without using CTE. If you are expecting a specific column name, you're welcome to tell us what you expect and why, but so far nobody has come up with any good reason for a specific form. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
