我有两个表tb1和tb2。我想从两个表中总结字段值。如何使用SQL语句执行此操作。 [英] I have two tables tb1 and tb2. I would like to sum up field values from two tables. How to do this using a SQL statement.

问题描述

tb1
Name Salary
Bob 1000
Tom 2000
John 3000
Winson 4000

tb2
Name Bonus
Bob 100
Tom 200


I would like to get the following result
Name Total
Bob 1100
Tom 2200
John 3000
Winson 4000

请建议如何解决它



我尝试过：

Please suggest how to resolve it

What I have tried:

SELEC tb1.Name, SUM(tb1.Salary + tb2.Bonus) Total From tb1, tb2 WHERE tb1.Name = tb2.Name group by tb1.Name order by Total

推荐答案

使用JOIN：

Use a JOIN:

SELECT t1.Name, COALESCE(t1.Salary + t2.Bonus, t1.Salary, t2.Bonus) AS Total FROM tb1 t1
LEFT JOIN tb2 t2 ON t1.Name = t2.Name 

这篇关于我有两个表tb1和tb2。我想从两个表中总结字段值。如何使用SQL语句执行此操作。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！