我想把当月和同期当月的数值在同一行显示,但是显示不出来去年当月的数值SELECT T1.month_id,T1.当月收入,T2.去年收入FROM(select month_id, nonoil_income as "当月收入" from ywgl_csrq where month_id between substr(current_date() , 1 ,4)||'01' and translate(substr(current_date() , 1 ,7),'-','')) t1left join(select month_id, nonoil_income as "去年收入" from ywgl_csrq where month_id between substr(monthdelta(today(),-12), 1 ,4)||'01' and translate(substr(monthdelta(today(),-12) , 1 ,7),'-','')) t2on t1.month_id = t2.month_id order by month_id