日期:2014-05-18 浏览次数:20565 次
select a.SceneName,isnull(b.s,0) as SumApplyNumber from SceneInfo a left join (select SceneId,sum(pplyNumber) as s from ApplyInfo group by SceneId) b on a.SceneId=b.SceneId