select c.* ,(isnull(c.期初库存,0) + isnull(c.进仓数量,0) + isnull(c.出仓数量,0)) as 结存数量 from (select distinct * from (SEL ECT 名称,仓库名称,数量 as 期初库存, 0 as 进仓数量,0 as 出仓数量 FROM {KC_QC} UNION
SEL ECT a.名称,a.仓库名称,0 as 期初库存 ,
( SEL ECT SUM(JCC数量) FROM {KC_JCCMX} where jcc数量 > 0 and 名称 = a.名称 and 仓库名称 = a.仓库名称 ) AS 进仓数量 ,
( SEL ECT SUM(JCC数量) FROM {KC_JCCMX} where jcc数量 < 0 and 名称 = a.名称 and 仓库名称 = a.仓库名称 ) AS 出仓数量
FROM {KC_JCCMX} AS a where a.仓库名称 = '祼机成品' and (a.JCCDate BETWEEN '2022-06-26' and '2022-06-30') GROUP BY a.名称,a.仓库名称) as a) as c