On 8/24/16, Richard Newman <rnew...@mozilla.com> 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 it as an identifier, or you can use a different name like "xinner". -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
