求助，在透视表中用select 语句进行多表合并遇到的问题

2005417 · 发表于 2009-5-13 10:36

其中求助的那张表是自己根据所在公司的实际情况所做，收发存报表为在论坛下载的参考资料。先谢谢各位

开心萝卜惠州 · 发表于 2009-5-13 11:07

其中SQL语句as 期初库存螺重不全啊，可以为0 as 期初库存螺重

2005417 · 发表于 2009-5-13 11:19

select "期初" as 日期,品种,型号,计量吨位 as 期初库存吨位,0 as 入库吨位,0 as 出库吨位,件数 as 期初库存件数,0 as 入库件数,0 as 出库件数,螺纹支数 as 期初库存支数,0 as 入库支数,0 as 出库支数,螺理重,as 期初库存螺重,0 as 入库螺重,0 as 出库螺重 from [期初$] union all select "入库" as 日期,品种,型号,0 as 期初库存吨位,计量吨位 as 入库吨位,0 as 出库吨位,0 as 期初库存件数,件数 as 入库件数,0 as 出库件数,0 as 期初库存支数,螺纹支数 as 入库支数,0 as 出库支数,0,as 期初库存螺重,螺理重 as 入库螺重,0 as 出库螺重 from [入库$] union all select "出库" as 日期,品种,型号,0 as 期初库存吨位,0 as 入库吨位,计量吨位 as 出库吨位,0 as 期初库存件数,0 as 入库件数,件数 as 出库件数,0 as 期初库存支数,0 as 入库支数,螺纹支数 as 出库支数,0,as 期初库存螺重,0 as 入库螺重,螺理重 as 出库螺重 from [出库$]

2005417 · 发表于 2009-5-13 11:20

自己从新写了个，还是不行，。。。。望指教，谢谢

2005417 · 发表于 2009-5-13 19:08

select "期初" as 日期,品种,型号,计量吨位 as 期初库存吨位,0 as 入库吨位,0 as 出库吨位,件数 as 期初库存件数,0 as 入库件数,0 as 出库件数, 螺纹支数 as 期初库存支数,0 as 入库支数,0 as 出库支数, 螺理重,as 期初库存螺重,0 as 入库螺重,0 as 出库螺重 from [期初$] union all select "入库" as 日期,品种,型号,0 as 期初库存吨位, 计量吨位 as 入库吨位,0 as 出库吨位, 0 as 期初库存件数, 件数 as 入库件数,0 as 出库件数, 0 as 期初库存支数, 螺纹支数 as 入库支数,0 as 出库支数, 0,as 期初库存螺重, 螺理重 as 入库螺重,0 as 出库螺重 from [入库$] union all select "出库" as 日期,品种,型号,0 as 期初库存吨位,0 as 入库吨位, 计量吨位 as 出库吨位, 0 as 期初库存件数, 0 as 入库件数, 件数 as 出库件数, 0 as 期初库存支数,0 as 入库支数, 螺纹支数 as 出库支数, 0 as 期初库存螺重,0 as 入库螺重, 螺理重 as 出库螺重 from [出库$]

2005417 · 发表于 2009-5-13 19:09

哪里出错了阿，就是不能生成透视表

小蚁雄兵 · 发表于 2009-5-13 19:52

原帖由 2005417 于 2009-5-13 19:09 发表
哪里出错了阿，就是不能生成透视表

建议楼主化繁入简地进行排错

jssy · 发表于 2009-5-14 09:36

这个SQL语句好象没什么问题,已帮你做了一个,你看看

收发存报表.rar (11.81 KB, 下载次数: 93)

jian0328 · 发表于 2010-7-22 14:21

厉害，谢谢了

		自动登录	找回密码
密码			免费注册