Do you know of any implementation of SQL that accepts an AS clause for the updated table? I don't think any do.
Some versions have a FROM extension and you CAN specify an alias for the updated table in that clause, however, as far as I know the update table cannot be aliased and the "set <column> = ..." the <column> must always be a column in the updated table and while you may be allowed to "adorn" it in some implementations, any adornments are ignored (or trigger an error message if they are not the same as the updated table). -- ˙uʍop-ǝpısdn sı ɹoʇıuoɯ ɹnoʎ 'sıɥʇ pɐǝɹ uɐɔ noʎ ɟı > -----Original Message----- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of John McMahon > Sent: Wednesday, 5 July, 2017 21:17 > To: SQLite Users > Subject: [sqlite] syntax error near AS > > Hi > > Wondering if someone else can spot the syntax error in the following > statement. "locns" is an attached database. There are four "AS" terms in > the statement, they all alias tables. > > Ok, found it. It seems that an alias for an "UPDATE" table name is not > permitted. Is there a particular reason for this? > I would think it a convenience especially when using long table names > and attached databases. > > John > > sqlite> UPDATE locns.xxx_last_delivery AS tgt > ... > SET > ... > tgt.del_date = ( > ... > SELECT src.last_del_d > ... > FROM main.updates AS src > ... > WHERE src.custnum = tgt.custnum), > ... > tgt.del_qty = ( > ... > SELECT src.last_del_q > ... > FROM main.updates AS src > ... > WHERE src.custnum = tgt.custnum) > ... > WHERE > ... > tgt.custnum = ( > ... > SELECT src.custnum > ... > FROM main.updates AS src > ... > WHERE src.last_del_d IS NOT NULL > ... > AND src.last_del_d > tgt.del_date) > ... > ; > Error: near "AS": syntax error > > -- > Regards > John McMahon > li...@jspect.fastmail.fm > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
