What?
I have to write select d as d. You are not
serious. You dont understand what I wrote.
I get select correct but create table as
does not have same name as select has. Why
different result?
If select gives some name I don't care what
I expect create table as give me same name.
Is this so hard to understand.
Simon Slavin je 22.12.2017 ob 17:58 napisal:
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
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
