lisa198588 发表于 2012-10-10 17:34
我参照吴想版主的方法,采用UNION ALL如下语句作多表联合查询,但是一直提示“查询无法运行或数据库无法打 ... - SELECT 日期,客户,终端客户,料号,[出\入库单号],仓别,属性,SUM(期初数量) AS 期初数量,SUM(入库数量) AS 入库数量,SUM(出库数量) AS 出库数量,SUM(期初数量+入库数量+出库数量) AS 库存结余,SUM(预估数量) AS 预估数量,SUM(拉货数量) AS 拉货数量,SUM(预估数量-入库数量-拉货数量) AS 预估余数 FROM
- (SELECT 日期,客户,终端客户,料号,拉货数量,[出\入库单号],仓别,属性,0 as 预估数量,0 as 出库数量,0 as 入库数量,0 as 期初数量 FROM [拉货$]
- UNION ALL
- SELECT 日期,客户,终端客户,料号,0,[出\入库单号],仓别,属性,预估数量,0,0,0 FROM [预估$]
- UNION ALL
- SELECT 日期,客户,终端客户,料号,0,[出\入库单号],仓别,属性,0,出库数量,0,0 FROM [出库$]
- UNION ALL
- SELECT 日期,客户,终端客户,料号,0,[出\入库单号],仓别,属性,0,0,入库数量,0 FROM [入库$]
- UNION ALL
- SELECT 日期,客户,终端客户,料号,0,[出\入库单号],仓别,属性,0,0,0,期初数量 FROM [期初$])
- GROUP BY 日期,客户,终端客户,料号,[出\入库单号],仓别,属性
复制代码
Book1.rar
(5.09 KB, 下载次数: 18)
|