I know the fact that DELETE and UPDATE don't accept a table alias has come up here a couple of years ago, but I think this should be filed as a bug because the syntax documentation explicitly shows it being accepted. Both statements are documented as taking a qualified-table-name:
qualified-table-name: https://www.sqlite.org/syntaxdiagrams.html#qualified-table-name Delete: https://www.sqlite.org/syntaxdiagrams.html#delete-stmt Update: https://www.sqlite.org/syntaxdiagrams.html#update-stmt And qualified-table-name has the optional [AS <alias>] component. This page places extra restrictions only in the context of triggers: https://www.sqlite.org/lang_delete.html Even the trigger restrictions do not mention the alias clause. -Jake Cobb _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users