Question

请教个问题 SQL语句多表链接查询 怎么实现下面图的内容 左边不显示重复数据

下面张图是想要的结果





Answer 1

SELECT T1.name,T1.buyAmount,T2.sellAmount FROM
(SELECT A.name,SUM(buyAmount) FROM A GROUP BY A.name) T1
LEFT JOIN
(SELECT B.name,SUM(sellAmount) FROM B GROUP BY B.name) T2
ON T1.name=T2.name

答案应该是这样子。先统计后联接

Answer 2

把编好的SQL语句，放在透视表里，就有这个效果