id_, main_id_, fill_date_, subject_code_, subject_name_, subject_name_en_, subject_unit_, actual_, budget_, variance_, last_time_ SELECT m.fill_year_ AS YEAR, SUM(d.actual_) AS actual, SUM(d.budget_) AS budget FROM qf_operation_company_cip_d d LEFT JOIN qf_operation_company_cip_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT m.fill_year_ AS YEAR, MAX(m.fill_month_) AS MONTH FROM qf_operation_company_cip_d d LEFT JOIN qf_operation_company_cip_m m ON m.id_ = d.main_id_ GROUP BY m.fill_year_ ) q ON q. YEAR = m.fill_year_ AND q. MONTH = m.fill_month_ and m.fill_year_ >= #{vo.startYear} AND #{vo.endYear} >= m.fill_year_ AND #{vo.year} = m.fill_year_ AND #{vo.enterprise_code_} = d.enterpriseCode GROUP BY m.fill_year_ ORDER BY m.fill_year_ SELECT m.fill_month_ as month, sum(d.actual_) as actual, sum(d.budget_) as budget FROM qf_operation_company_cip_d d LEFT JOIN qf_operation_company_cip_m m ON m.id_ = d.main_id_ and m.fill_year_ = #{vo.year} and m.fill_month_ >= #{vo.startMonth} AND #{vo.endMonth} >= m.fill_month_ AND #{vo.enterprise_code_} = d.enterpriseCode GROUP BY m.fill_month_ ORDER BY m.fill_month_ ASC SELECT d.enterprise_code_, sum(d.actual_) AS actual, sum(d.budget_) AS budget FROM qf_operation_company_cip_d d LEFT JOIN qf_operation_company_cip_m m ON m.id_ = d.main_id_ LEFT JOIN ( SELECT d.enterprise_code_, max(m.fill_month_) AS month FROM qf_operation_company_cip_d d LEFT JOIN qf_operation_company_cip_m m ON m.id_ = d.main_id_ GROUP BY d.enterprise_code_ ) q on q.month = m.fill_month_ AND #{vo.year} = m.fill_year_ AND d.enterprise_code_ = #{vo.enterpriseCode} GROUP BY d.enterprise_code_ ORDER BY d.enterprise_code_