Acess 中sql 语句有错误

来源：百度知道 编辑：UC知道 时间：2024/06/08 09:34:24
select serialcode as 序号, starttime as 开始时间,endtime as 结束时间, 评价结果= case when commentresult =0 or commentresult = -1 then '未评价' when commentresult =1 then '非常满意' when commentresult =2 or commentresult =3 then '满意' when commentresult =4 then '不满意' end from TMP_CQ_Cmn_History where starttime between # 00:00:00# and # 23:59:59#) order by starttime desc

报出 语法错误。操作符丢失

select serialcode as 序号, starttime as 开始时间,endtime as 结束时间, case when commentresult =0 or commentresult = -1 then '未评价' when commentresult =1 then '非常满意' when commentresult =2 or commentresult =3 then '满意' when commentresult =4 then '不满意' end as 评价结果 from TMP_CQ_Cmn_History where starttime between # 00:00:00# and # 23:59:59# order by starttime desc

这样试试