Re: [sqlite] `SELECT FROM ( subquery ) alias` seems to require `AS`

On 8/24/16, Richard Newman wrote: > sqlite> SELECT DISTINCT inner.uri AS uri FROM >...> (SELECT DISTINCT v AS uri FROM bar) >...> inner; > Error: near ";": syntax error > "Inner" is a keyword. You can put it in double-quotes to let SQLite know that you want to use

Re: [sqlite] `SELECT FROM ( subquery ) alias` seems to require `AS`

Please retry your test without using keywords like "inner" as an alias for something. regards, Adam On Wed, Aug 24, 2016 at 11:26 PM, Richard Newman wrote: > Hi folks, > > According to my reading of < > https://www.sqlite.org/syntax/table-or-subquery.html>, a table alias

[sqlite] `SELECT FROM ( subquery ) alias` seems to require `AS`

Hi folks, According to my reading of < https://www.sqlite.org/syntax/table-or-subquery.html>, a table alias for a subquery does not require an AS; that is, SELECT noo.foo FROM ( SELECT … FROM bar ) AS noo is equivalent to SELECT noo.foo FROM ( SELECT … FROM bar ) noo This does not seem to