SELECT "仓库编码","存货编码", SUM("入库") AS"入库总件数",SUM("入库重量")AS"入库总重量" ,SUM("调出件数") AS"调出总件数",SUM("调出重量") AS"调出总重量",SUM("调入件数") AS"调入总件数",SUM("调入重量") AS"调入总重量",SUM("出库") AS"出库总件数" ,SUM("出库重量") AS"出库总重量" FROM
(SELECT "仓库编码","存货编码","件数" as "入库","重量" AS"入库重量",0 as "出库",0 AS"出库重量",0 AS"调出件数",0 as "调出重量",0 AS"调入件数",0 as "调入重量" from "入库详情表"
UNION
SELECT "仓库编码","存货编码",0 as "入库" ,0 as"入库重量","件数" as "出库","重量"AS"出库重量",0 AS"调出件数",0 as "调出重量",0 AS"调入件数",0 as "调入重量" FROM "出库详情表"
UNION
SELECT "调出仓库","存货编码",0 as "入库" ,0 as"入库重量",0 as "出库",0 AS"出库重量" ,"调出件数","调出重量",0 AS"调入件数",0 as "调入重量" FROM "调拨详情表"
UNION
SELECT "调入仓库","存货编码",0 as "入库" ,0 as"入库重量",0 as "出库",0 AS"出库重量", 0 AS"调出件数",0 as "调出重量","调入件数","调入重量" FROM "调拨详情表"
) AS "AAA"
GROUP BY "仓库编码","存货编码"
|