在MS访问查询设计中，此查询中缺少运算符错误 [英] Getting missing operator error in this query in MS access query design

问题描述

<预郎= SQL> <跨度类= 代码关键字>更新 TEMP1一个 SET TimeStamp1 = <跨度类= code-keyword> CASE （ WHEN （a.TimeStamp1 IN （ SELECT TimeStamp1 FROM a WHERE a.DealName = ' Disha Rufous' AND a.DealStep = ' 发送风险反馈'） - a.TimeStamp1 IN （ SELECT TimeStamp1 FROM a WHERE a.DealName = ' Disha Rufous' AND a.DealStep = ' 收到重复数据删除确认） IS NOT NULL THEN ' 0 ' ELSE TimeStamp1 END ） WHERE Temp1.DealName = ' dede' AND Temp1.StepName = ' 风险反馈已解决'

错误发生在

 那么 

我尝试过：



尝试使用不同的组合但不起作用

解决方案

删除CASE和WHEN之间的括号（它的匹配关闭brac KET）。

UPDATE Temp1 a SET TimeStamp1 = CASE(WHEN (a.TimeStamp1 IN(SELECT TimeStamp1 FROM a WHERE a.DealName = 'Disha Rufous' AND a.DealStep = 'Sent for Risk feedback') - a.TimeStamp1 IN(SELECT TimeStamp1 FROM a WHERE a.DealName = 'Disha Rufous' AND a.DealStep = 'De-dupe confirmation received') IS NOT NULL THEN '0'  ELSE TimeStamp1 END) WHERE Temp1.DealName = 'dede' AND Temp1.StepName = 'Risk feedback addressed'

Error is occurring at

THEN

What I have tried:

Tries using different combinations but doesn't work

解决方案

Remove the bracket between CASE and WHEN (and it's matching close bracket).

这篇关于在MS访问查询设计中，此查询中缺少运算符错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！