select*from(SELECT DISTINCT RepMonth as RepMonthFROM obj_date WHERE RepDate <= NOW() AND DATE_FORMAT( RepDate, '%Y' ) = DATE_FORMAT(NOW(),'%Y')) odLEFT JOIN(SELECT IFNULL(count(DISTINCT project_id)/ (select count(id) as total from system_project where org_id = (select id from sys_depart where depart_name = '苏南分公司') and depart_id in (select id from sys_depart where depart_name = '历史研究院' )),0.01) as '填报率', CONCAT(MONTH(create_time),'月') as '月份'FROM aq_identificationlist WHERE branch_office = '苏南分公司' and date_format( create_time, '%Y' )= '2022' and bpm_status != '1' and bpm_status != '4' and project_id in (select id from system_project where depart_id in (select id from sys_depart where depart_name = '历史研究院' )) GROUP BY CONCAT(MONTH(create_time),'月') ) bo on od.RepMonth = bo.月份