UPDATE X1 ;
SET AddressCoefficient = IIF(X1.Address IN (SELECT Address FROM X1 WHERE !EMPTY(Address) GROUP BY Address HAVING COUNT(*) > 1), 0.1, 0)

对X1表中的AddressCoefficient 字段进行更新，使用了IIF函数，这里X1.Address IN (SELECT Address FROM X1 WHERE !EMPTY(Address) GROUP BY Address HAVING COUNT(*) > 1) 是不是不能作为判断条件？？一直提示缺少逗号(,)

收到，谢谢