On 8/24/16, Richard Newman <[email protected]> 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 [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
