22,210
社区成员
发帖
与我相关
我的任务
分享
SELECT
SUM(isnull(数量, 0)) AS 入库数
FROM
入出库
INNER JOIN 入出库明细
ON 入出库.管理NO = 入出库明细.管理NO
WHERE
AND 入出库.仓库CD = 1
AND 入出库明细.商品CD1 = 7096641
AND 入出库明细.商品CD2 = 0
SELECT
SUM(isnull(数量, 0)) AS 入库数
FROM
入出库
INNER JOIN 入出库明细
ON 入出库.管理NO = 入出库明细.管理NO
WHERE
AND 入出库.仓库CD = 1
AND 入出库明细.商品CD1 = 7096641
AND 入出库明细.商品CD2 = 0
option (force order)