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