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