How to calculate the sum of data from two tables in SQL?

In SQL, you can use JOIN and SUM functions to calculate the sum of data from two tables. If you have two tables, table1 and table2, that share a common column, id, you can calculate the sum as follows:

SELECT table1.id, SUM(table1.column_name + table2.column_name) AS total_sum
FROM table1
JOIN table2 ON table1.id = table2.id
GROUP BY table1.id;

In this example, ‘column_name’ is the name of the column to be summed. The JOIN statement is used to connect two tables using a common id column to match them. The SUM function is used to calculate the total value of the corresponding column. Lastly, the GROUP BY statement is used to group the data by id in order to calculate the sum for each id.

Please note that this is just a simple example, and actual adjustments may be needed based on specific table structures and requirements when using it.