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_0004where YEAR || MONTH =(SELECT MAX(YEAR || MONTH)FROM MAMC00.T_ADS_SRV_JYAC_0004where 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)t1left join(select YEAR || MONTH AS TIME,PROD_CLASS_NAME,PROCESSING_COST 月预算from MAMC00.T_ADS_SRV_JYAC_0007where YEAR || MONTH =(SELECT MAX(YEAR || MONTH)FROM MAMC00.T_ADS_SRV_JYAC_0007where 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