On 2016/01/16 10:18 AM, audio muze wrote: > Thanks Keith > > That's what I'd tried with my first attempt but naturally it didn't work. > > Why is it that SQLite does not support a FROM clause in an update statement?
Because of the intent expressed with the word "Lite" in SQLite and the fact similar can be achieved with minimal restructuring of the SQL. Adding UPDATE .. FROM functionality is seemingly quite a bit of code to add - but I have to agree, that would make a really nice addition to SQLite. To the Devs: Considering recent additions and developments (CTE etc.), is this not relatively more easy to add now?
