위 두개 쿼리는 하나로 합칠 수 있겠네요.
SELECT rdate , LEFT(rdate, 4) ryear , RIGHT(rdate, 2) rmonth , name , SUM(i_cnt ) i_cnt , SUM(i_price ) i_price , SUM(p_cnt ) p_cnt , SUM(p_price ) p_price , SUM(a_cnt ) a_cnt , SUM(a_price ) a_price , SUM(p_margin) p_margin FROM (SELECT DATE_FORMAT(t.reg_date, '%Y-%m') rdate , t.cname name , COUNT(CASE WHEN t.pstate IN ('03', '10') AND t.astate != '05' THEN 1 END) i_cnt , SUM( CASE WHEN t.pstate IN ('03', '10') AND t.astate != '05' THEN t.pkg_price END) i_price , COUNT(CASE WHEN t.pstate IN ('05', '06') THEN 1 END) p_cnt , SUM( CASE WHEN t.pstate IN ('05', '06') THEN t.pkg_price END) p_price , 0 a_cnt , 0 a_price , 0 p_margin FROM tablee t WHERE t.pstate IN ('03', '10', '05', '06') AND t.reg_date >= #startDate:DATE# AND t.reg_date < #endDate:DATE# + INTERVAL 1 DAY GROUP BY DATE_FORMAT(t.reg_date, '%Y-%m'), t.ccd UNION ALL SELECT DATE_FORMAT(t.a_date, '%Y-%m') rdate , t.cname name , 0 i_cnt , 0 i_price , 0 p_cnt , 0 p_price , COUNT(*) a_cnt , SUM(t.apri) a_price , SUM(t.pamt) p_margin FROM tablee t WHERE t.pstate IN ('01', '02', '03', '04') AND t.astate = '99' AND t.a_date >= #startDate:DATE# AND t.a_date < #endDate:DATE# + INTERVAL 1 DAY GROUP BY DATE_FORMAT(t.a_date, '%Y-%m'), t.ccd ) GROUP BY rdate, name ORDER BY rdate, name ;