oracle sql的一个sum()查询问题

Question

这两个我需要把他们合并起来的效果,
最左边那列是部门,然后是当日ymcl,然后是本月的ymcl合计
dname ymcl sumymcl(从一号到今日的sum)
部门1 11 363
部门2 12 321
部门3 13 514

    SELECT d.name as dname,info2.ymcl,(
               SELECT sum(info.ymcl) FROM day_out_info info 
               LEFT JOIN day_out_record re ON re.id=info.record_id
                WHERE re.yyyy=2015 AND re.mm=10 AND re.dd BETWEEN '1' AND '23'-- group by re.dept_id
              ) AS sumymcl
 FROM day_out_info info2
 LEFT JOIN day_out_record re2 ON re2.id=info2.record_id
 LEFT JOIN s_dept d ON d.id=re2.dept_id
 WHERE re2.dd=23 

    sql这样写 出来的 SUM值是把所有部门的都SUM起来了,如何才能分部门SUM

Answer 1

把(
SELECT sum(info.ymcl) FROM day_out_info info
LEFT JOIN day_out_record re ON re.id=info.record_id
WHERE re.yyyy=2015 AND re.mm=10 AND re.dd BETWEEN '1' AND '23'-- group by re.dept_id
) AS sumymcl
改成inner join 的结果集，同时加上group by re.dept_id