On Mon, Jan 15, 2018 at 5:14 AM, Clemens Ladisch <clem...@ladisch.de> wrote:
> J Decker wrote:
> > What is the expected output?
>
> And just out of curiosity: what should the table name be for these columns?
>
> SELECT articles.gmt_deleted+tags.type, 42, id FROM articles JOIN tags
> USING (id);
>
>
table name wouldn't matter.
create table articles ( id, content,gmt_deleted ) " );
create table tags ( id,type, text ) " );
insert into articles (id,content,gmt_deleted) values ( 1, 'hello
world','X')" );
insert into tags (id,type,text) values ( 1, 'text', 'MOTD')" );
SELECT articles.gmt_deleted+tags.type, 42, articles.id FROM articles JOIN
tags on articles.id=tags.id;" ) );
[ { '42': 42, 'articles.gmt_deleted+tags.type': 0, id: 1 } ]
>
> Regards,
> Clemens
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
