做了个SQL,结果发现期初库存,哪去了,无语,没办法帮你构造这个表格- select 月份&'月' as 月份,类别,材料名称,规格,单位,sum(入库数量) as 入库数量,sum(出库数量) as 出库数量,sum(入库数量)-sum(出库数量) as 期末数量 from (select month(日期) as 月份,类别,材料名称,规格,单位,数量 as 入库数量,0 as 出库数量 from [入库清单$B:G] where 类别<>0 union all select month(日期) as 月份,类别,材料名称,规格,单位,0 as 入库数量,数量 as 出库数量 from [出库清单$B:G] where 类别<>0) group by 月份,类别,材料名称,规格,单位
复制代码 |