select '本月',a.值 from ( select by_income as 值 from app_db.zhy_fyyw_xl_m_hy where calmonth = translate(substr(current_date() , 1 ,7 ),'-','') ) as a union select '上月',a.值 from ( select sy_income as 值 from app_db.zhy_fyyw_xl_m_hy where calmonth = translate(substr(current_date() , 1 ,7 ),'-','') ) as a union select '同期',a.值 from ( select tq_income as 值 from app_db.zhy_fyyw_xl_m_hy where calmonth = translate(substr(current_date() , 1 ,7 ),'-','') ) as a union select '同比',a.值 from ( select tb_income_rate as 值 from app_db.zhy_fyyw_xl_m_hy where calmonth = translate(substr(current_date() , 1 ,7 ),'-','') ) as a union select '环比',a.值 from ( select hb_income_rate as 值 from app_db.zhy_fyyw_xl_m_hy where calmonth = translate(substr(current_date() , 1 ,7 ),'-','') ) as a |