一个主表连接二个未算和的附表，通过临时表的方式

分别测试待合并的数据

详细SQL:

SELECT sum(s.Count) as ssumCount,s.CustormerId as scId from
recordsuccessbycustomer as s
group by s.CustormerId

SELECT sum(f.Count) as fsumCount,f.CustormerId as fcId from
recordfailedbycustomer as f
group by f.CustormerId

SELECT a.Count,a.CustormerId  from
recordallbycustomer as a
group by a.CustormerId

 连接三个表：

在连接前算和并分组。

SELECT a.CustormerId,a.serial,a.special ,a.Count,ssumCount ,fsumCount,(a.Count-temp1.ssumCount-temp2.fsumCount) as NullCount from 
recordallbycustomer as a LEFT JOIN 
(
SELECT sum(s.Count) as ssumCount,s.CustormerId as scId from
recordsuccessbycustomer as s
group by s.CustormerId
)
temp1
on a.CustormerId=temp1.scId
left JOIN
(
SELECT sum(f.Count) as fsumCount,f.CustormerId as fcId from
recordfailedbycustomer as f
group by f.CustormerId
)
temp2
on a.CustormerId=temp2.fcId

group by a.CustormerId
HAVING a.CustormerId="ec9af239b1e9499c9c616e2b92edaf77"