select '日期:'||substr(t1.time,1,4)||'.'||substr(t1.time,5,2) time, t1.PROD_CLASS_NAME, t1.月实际, t2.月预算 from (select YEAR || MONTH AS TIME,PROD_CLASS_NAME,PROCESSING_COST 月实际 from MAMC00.T_ADS_SRV_JYAC_0004 where YEAR || MONTH =(SELECT MAX(YEAR || MONTH)FROM MAMC00.T_ADS_SRV_JYAC_0004 where 1=1 ${if(len(COMPANY_NAME) == 0,"","and COMPANY_NAME = '" + COMPANY_NAME + "'")} ) ${if(len(COMPANY_NAME) == 0,"","and COMPANY_NAME = '" + COMPANY_NAME + "'")} group by YEAR ||MONTH,PROD_CLASS_NAME,PROCESSING_COST)t1 left join ( select YEAR || MONTH AS TIME,PROD_CLASS_NAME,PROCESSING_COST 月预算 from MAMC00.T_ADS_SRV_JYAC_0007 where YEAR || MONTH =(SELECT MAX(YEAR || MONTH)FROM MAMC00.T_ADS_SRV_JYAC_0007 where 1=1 ${if(len(COMPANY_NAME) == 0,"","and COMPANY_NAME = '" + COMPANY_NAME + "'")} ) ${if(len(COMPANY_NAME) == 0,"","and COMPANY_NAME = '" + COMPANY_NAME + "'")} group by YEAR ||MONTH,PROD_CLASS_NAME,PROCESSING_COST ) t2 on t1.time=t2.time |