On 06/07/2017 16:33, Clemens Ladisch wrote:
John McMahon wrote:
an alias for an "UPDATE" table name is not permitted. Is there a particular
reason for this?
The UPDATE statement affects a single table. While an alias might be
a convenience, it is not necessary (any naming conflicts in subqueries
can be resolved by using an alias on the table(s) used there).
Thank you Clemens, I see now, the need for no ambiguities when updating.
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
--
Regards
John McMahon
j...@jspect.fastmail.com.au
04 2933 4203
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users