--没有时添加select Name,other,sum(Number) as Number from B where not exists(select 1 from A where Name=b.Name and Other=a.Other)group by Name,other
