SQLite Forum

What is the recommended way to update multiple columns from a single select?
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.