错误提示:
.NET Framework 版本:4.0.30319.42000
Foxtable 版本:2022.5.27.2
错误所在事件:
详细错误信息:
'(' 附近有语法错误。
下面红色内的代码单独运行没有问题。
sel ect c.*,d.数量 as 期初库存,(d.数量 + c.进仓数量 + c.出仓数量) as 结存数量 from {
S ELECT a.JCCDate,a.名称,SUM(a.JCC数量) AS 进仓数量, (SEL ECT SUM(JCC数量) FROM {KC_JCCMX} where jcc数量 < 0 and 名称 = a.名称 and
JCCDate = a.JCCDate ) AS 出仓数量 FROM {KC_JCCMX} AS a where a.jcc数量 > 0 and a.仓库名称 = '祼机成品' and
a.JCCDate BETWEEN '2022-06-26' and
'2022-06-30' GROUP BY a.JCCDate ,a.名称 order BY a.JCCDate
,a.名称 } As c left Join {KC_QC} As
d On c.名称 = d.名称 And c.仓库名称 = d.仓库名称