关键字 ‘IN’附近有语法错误。这个怎么解决

公式不符合规范 可以点出错提示底部的详细，将您的公式贴出来这样好判断

SELECT T_218.F_2047 AS F_2312xFP,
SUM(T_218.F_2053) AS F_2316xFN
FROM  T_218  WHERE 1=1 AND  [T_218].[F_2054]  <IN (60,60,60,60,1,1,60,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,1,60,60,1,1,1,60,1,1,60,1,1,60,60,60,60,60,60,60,60,1,1,1,60,60,60,60,60,60,60,60,60,60,60,1,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,60,1,60,1,1,60,60,60,60,1,60,60,1,60,60,60,60,60,60,60,60,1,60,60,60,1,60,60,1,60,60,1,60,1,60,60,60,1,60,1,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,1,1,1,60,60,60,1,1,60,60,1,1,60,60,1,1,60,60,60,60,60,60,60,60,60,1,60,1,1,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,1,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,1,60,60,60,60,60,1,60,60,60,60,1,60,60,60,60,60,0,60,60,60,60,60,60,60,60,60,60,60,60,60)  GROUP BY [T_218].[F_2047]

< IN  明细表只能用属于不属于 IN 或 NOT IN 不能含有 < 等。

那我怎样才能取到查询表内小于30天的数呢？

AND 本报表字段  < 30

公式不符合规范 可以点出错提示底部的详细，将您的公式贴出来这样好判断

SELECT T_218.F_2047 AS F_2312xFP,
SUM(T_218.F_2053) AS F_2316xFN
FROM  T_218  WHERE 1=1 AND  [T_218].[F_2054]  <IN (60,60,60,60,1,1,60,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,1,60,60,1,1,1,60,1,1,60,1,1,60,60,60,60,60,60,60,60,1,1,1,60,60,60,60,60,60,60,60,60,60,60,1,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,60,1,60,1,1,60,60,60,60,1,60,60,1,60,60,60,60,60,60,60,60,1,60,60,60,1,60,60,1,60,60,1,60,1,60,60,60,1,60,1,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,1,1,1,60,60,60,1,1,60,60,1,1,60,60,1,1,60,60,60,60,60,60,60,60,60,1,60,1,1,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,60,1,60,1,60,60,60,60,60,60,60,60,60,1,60,60,60,60,60,60,60,60,1,60,60,60,60,60,1,60,60,60,60,1,60,60,60,60,60,0,60,60,60,60,60,60,60,60,60,60,60,60,60)  GROUP BY [T_218].[F_2047]

< IN  明细表只能用属于不属于 IN 或 NOT IN 不能含有 < 等。

那我怎样才能取到查询表内小于30天的数呢？

AND 本报表字段  < 30