SQLite Forum

Pre-release Versions of System.Data.SQLite packages?
The UPDATE ... FROM ... query syntax that was added to SQLite3 in version 3.33.0 is not compatible with the Sybase UPDATE ... FROM ... syntax supported by Microsoft products.


You are aware that even though support for UPDATE ... FROM ... was added, you will only be able to use that capability from "native SQL" and that Microsoft products (like Access) will neither be able to parse (make pretty pictures from) nor compose (make pretty pictures into) SQL where UPDATE ... FROM ... is concerned?