On 22 Dec 2017, at 4:50pm, Radovan Antloga <[email protected]> wrote:
> select d from (select c AS d from (select a AS c from test)); > > I get d as column name. If I create table with > create table as I get a as column name. As I wrote, you did not specify AS for d, so you cannot depend on a column name. If you want to know what the column will be called, specify AS: select d AS myColumnNameHere from (select c AS d from (select a AS c from test)); Now you know what the column will be called. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
