报错缺失表达式，哪位大神帮我看看？

[afeiwyk]

insert into lubbase("序号","根目录","二级目录","三级目录"，"四级目录","五级目录","六级目录","部件名称","部件型号","单位","装机数量","润滑油脂型号","加注量","加注单位","加注日期","加注周期(天)","油脂单价","油脂总价" ) select"序号","根目录","二级目录","三级目录","四级目录","五级目录","六级目录","部件名称","部件型号","单位","装机数量","润滑油脂型号","加注量","加注单位",max("加注日期"),"加注周期(天)","油脂单价","油脂总价",case when dateadd(day,"加注周期(天)",max("加注日期"))>=convert(date,getdate()) then '到期' else '未到期' end from lubtable group by"序号","根目录","二级目录","三级目录","四级目录","五级目录","六级目录","部件名称","部件型号";


5000行都熬过来了，卡在这里了

[lhdz_bj]

1、楼主这应该是SQL SERVER的库；
2、问题应该在group by上？

[ZJHZ_叶]

你select是不是多一行了，油脂总价后面

[ZJHZ_叶]

而且你这个select 会报错吧

[afeiwyk]

引用 1 楼 ZJHZ_叶 的回复:

你select是不是多一行了，油脂总价后面

大神说清楚点啊

[walkonroad]

看了一下你的sql，
发现有两个问题：
1.insert into的列对不上会报错；
2.select查询里面的group by用法和你查询的列不匹配会报错。