Question

SQL查询两个表相同的两个字段里相同的数据有哪些

例子 TABLE1 TABLE2
xingming qian xingming qian
张三 5 张三 10
张三 15 张三 10
李四 20 李四 15
王五 20 李四 10
赵二 21 王五 30

王五 10
要姓名相同，钱也要相同 ，要先把名字相同的 ，钱加起来。
结果：张三 王五 查询语句怎么写？

Answer 1

select xingming,sum(qian)
from (
select xingming,qian from table1
union all
select xingming,qian from table2)
group by xingming,qian
having count(xingming)>1

Answer 2

select xingming,sum(qian1 ) as qian from
(select xingming,sum(qian) as qian1 from table1 group by xingming
union
select xingming,sum(qian) as qian1 from table2 group by xingming) as a