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 be the case with 3.14.1: SQLite version 3.14.1 2016-08-11 18:53:32 Enter ".help" for usage hints. sqlite> CREATE TABLE bar (e BLOB, a BLOB, v BLOB); sqlite> SELECT DISTINCT inner.uri AS uri FROM ...> (SELECT DISTINCT v AS uri FROM bar) ...> AS inner; sqlite> SELECT DISTINCT inner.uri AS uri FROM ...> (SELECT DISTINCT v AS uri FROM bar) ...> inner; Error: near ";": syntax error Am I misreading the docs, or is this a bug? Thanks, -Richard _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
