SELECT concatyearnavicatgroup_concat,LPADmonthnavicatgroup_concat,2,0 as ym ,year ,month ,sumtaking as heFROM t_scenicspot_monthly 去掉单引号试试,年份加月份可以看作是整形数据where concatyear,LPADmonth,2,0= and concatyear,LPADmonth,2,0lt=GROUP BY year,month#不知道navicatgroup_concat你值得项目是什。