select a.医生姓名,sum(isnull(a.诊断数量,0))+sum(isnull(b.审核数量,0)) 报告数量,sum(isnull(a.诊断数量,0)) 诊断数量,sum(isnull(b.审核数量,0)) 审核数量
from table1 as a left join temp2 as b on (a.医生姓名=b.医生姓名e) group by a.医生姓名
union
select a.医生姓名,sum(isnull(b.诊断数量,0))+sum(isnull(a.审核数量,0)) 报告数量,sum(isnull(b.诊断数量,0)) 诊断数量,sum(isnull(a.审核数量,0)) 审核数量
from table2 as a left outer join temp1 as b on (a.医生姓名=b.医生姓名) group by a.医生姓名