sekect b.SceneName,a.sum from (select SceneId,sum(ApplyNumber) as sum from ApplyInfo group by SceneId) a join SceneInfo b on a.SceneId=b.SceneId
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
(select SceneId,sum(ApplyNumber) as sum from ApplyInfo group by SceneId) a join
SceneInfo b on a.SceneId=b.SceneId
from SceneInfo a
left join
(select SceneId,sum(pplyNumber) as s from ApplyInfo group by SceneId) b
on a.SceneId=b.SceneId