我理解你的意思可能是统计出如下结果
name sum(num)
a 3
b 2
c 4
d 0
e 0方法一:(未测试)
select b.name , isnull(sum(isnull(num,0)),0)
from b_rel b,a_rel a
where a.name *= b.name
group by b.name
方法二:(如果一不行的话)
select b.name , num = 0
into #temp
from b_rel
update #temp
set num = isnull(as_num,0)
from (select name , sum(isnull(num,0)) as_num, from a_rel group by name) BBCC
WHERE #temp.name = BBCC.name
SELECT * FROM #TEMP
name sum(num)
a 3
b 2
c 4
d 0
e 0方法一:(未测试)
select b.name , isnull(sum(isnull(num,0)),0)
from b_rel b,a_rel a
where a.name *= b.name
group by b.name
方法二:(如果一不行的话)
select b.name , num = 0
into #temp
from b_rel
update #temp
set num = isnull(as_num,0)
from (select name , sum(isnull(num,0)) as_num, from a_rel group by name) BBCC
WHERE #temp.name = BBCC.name
SELECT * FROM #TEMP
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货