How to copy value from one table to another SQLite?

Question

Python

I have two tables and there is a value that should be in two tables at once, but I can only make calculations in order for this value to appear in a cell in the first table. So the question is: how can I bring this value from a cell in the first table, to a cell in the second table (the values ​​of other cells in the row should not change). I'm guessing I'll have to use UPDATE, but how do I insert it into the second table so that I can add/subtract that value later without breaking anything? Thanks in advance for your replies.

Answer 1

insert into ... select ...
update ... set ... = select ...