表1:
name point
bob 20
bob 30
mike 38
表2:
name point
bob 53
mike 15
mike 38
如上所示,表一、表二结构相同,现在想求bob表一表二point之和,即20+30+53
要求一条sql语句实现(注意只能用一条sql语句),请教高人如何实现?
...全文
7537打赏收藏
sql多表字段求和
表1: name point bob 20 bob 30 mike 38 表2: name point bob 53 mike 15 mike 38 如上所示,表一、表二结构相同,现在想求bob表一表二point之和,即20+30+53 要求一条sql语句实现(注意只能用一条sql语句),请教高人如何实现?
select name, sum(point) as totalPoint
from
(select name, point
from 表1
where 表1.name = 'bob'
union all
select name, point
from 表2
where 表2.name = 'bob') as a
group by a.name