主题：[求助]同样的SQL语句，在查询表里可以执行，但在代码中不执行

sel ect v.FNumber, v.FModel, v.FName, v.CDate, v.MDate, v.Qty ,v.NDayS,Case when V.Ndays >= 365 then '1年以上' when V.Ndays >= 30 and V.Ndays < 365 then '1年' when V.Ndays > 0 then '1月' when V.Ndays IS null then '呆滞' end as Lx From (SEL ECT FNumber, FModel, FName, CDate, MDate, Qty, DATEDIFF(DAY, MDate, CDate) AS NDayS FROM (SEL ECT w.FItemID, w.FNumber, w.FModel, w.FName, GETDATE() AS CDate, (SEL ECT MAX(FDate) AS Expr1 FROM (SELE CT a.FItemID, b.FDate, a.FInterID FROM {ICStockBillEntry} AS a LEFT OUTER JOIN {ICStockBill} AS b ON a.FInterID = b.FInterID) AS c WHERE (FItemID = w.FItemID)) AS MDate,(SE LECT TOP (1) FQty FROM {ICInventory} AS K WHERE (FItemID = w.FItemID)) AS Qty FROM {t_ICItemCore} AS w ) AS J) as V order by v.FNumber

语句内容如上，不知那里出问题了。

此主题相关图片如下：微信截图_202501141637551.png

此主题相关图片如下：微信截图_20250114163834.png


此主题相关图片如下：微信截图_20250114164044.png