SELECT
T1.month_id,T1.当月收入,T2.去年收入
FROM
(
select month_id, nonoil_income as "当月收入" from ywgl_csrq_fy_hy where month_id between substr(current_date() , 1 ,4)||'01' and translate(substr(current_date() , 1 ,7),'-','')
) t1
left join
(
select month_id, nonoil_income as "去年收入" from ywgl_csrq_fy_hy where month_id between substr(DATE_ADD(CURRENT_DATE(),INTERVAL -1 YEAR) , 1 ,4)||'01' and translate(substr(DATE_ADD(CURRENT_DATE(),INTERVAL -1 YEAR) , 1 ,7),'-','')
) t2
on t1.month_id = LEFT(t2.month_id,4) - 1 || right(t2.month_id,2)
关联条件你试一下,应该是这样没问题