Thank you for this reply My sqlite version is 3.34.0.<br> According to JetBrains DataGrip (the application I am using to test my queries) this version is the latest-stable for sqlite. The UPDATE FROM example you gave above is working very good for me, thank you! For some reason the UPDATE FROM example with the (SELECT...) gives me the error.