select khjc,ckjc,spmc,dw,gg,ph, 结存数量, 0 as 入库数量,0 as 出库数量, 结存吨数,0 as 入库吨数,0 as 出库吨数,结存方数,0 as 入库方数, 0 as 出库方数 from qryCode_jcmx
UNION ALL select khjc,ckjc,spmc,dw,gg,ph, 0 as 结存数量,入库数量, 0 as 出库数量,0 as 结存吨数, 入库吨数,0 as 出库吨数,0 as 结存方数,入库方数,0 as 出库方数 from qryCode_rkmx
UNION ALL select khjc,ckjc,spmc,dw,gg,ph, 0 as 结存数量,0 as 入库数量, 出库数量, 0 as 结存吨数,0 as 入库吨数, 出库吨数,0 as 结存方数,0 as 入库方数,出库方数 from qryCode_ckmx;
原先在Access中正常使用,升迁到SQL server后这三个语句单独都可以执行,任意两个使用union all也可以执行。但是三个一起时报字段太小的错误。检查发现并没有问题。
最后是把后两个SQL语句用括号括起来解决了的
select khjc,ckjc,spmc,dw,gg,ph, 结存数量, 0 as 入库数量,0 as 出库数量, 结存吨数,0 as 入库吨数,0 as 出库吨数,结存方数,0 as 入库方数, 0 as 出库方数 from qryCode_jcmx
UNION ALL (select khjc,ckjc,spmc,dw,gg,ph, 0 as 结存数量,入库数量, 0 as 出库数量,0 as 结存吨数, 入库吨数,0 as 出库吨数,0 as 结存方数,入库方数,0 as 出库方数 from qryCode_rkmx
UNION ALL select khjc,ckjc,spmc,dw,gg,ph, 0 as 结存数量,0 as 入库数量, 出库数量, 0 as 结存吨数,0 as 入库吨数, 出库吨数,0 as 结存方数,0 as 入库方数,出库方数 from qryCode_ckmx);