再次求助 这个表的最后一个效果表 是怎么达到的

w112411538

谁可以  帮我写SQL语言啊   我写了个但是不怎么对

[ 本帖最后由 w112411538 于 2010-7-24 10:55 编辑 ]

w112411538

select A1.*,A2.订单数量 from

(select 物料长代码,物料名称,规格型号,实收数量 as 上月入库数量,0 as 本月入库数量,0 as 上月发货数量，0 as 本月发货数量,0 as 库存数量 from [上月入库数量$] union all

select 物料长代码,物料名称,规格型号,实收数量 as 本月入库数量,0 as 上月入库数量,0 as 上月发货数量，0 as 本月发货数量,0 as 库存数量 from [本月入库数量$] union all

select 物料长代码,物料名称,规格型号,0 as 上月入库数量,0 as 本月入库数量,基本单位调拨数量 as 上月发货数量,0 as 本月发货数量,0 as 库存数量 from [上月发货数量$] union all

select 物料长代码,物料名称,规格型号,0 as 上月入库数量,0 as 本月入库数量,基本单位调拨数量 as 本月发货数量,0 as 上月发货数量,0 as 库存数量 from [本月发货数量$] union all

select 物料长代码,物料名称,规格型号,0 as 上月入库数量,0 as 本月入库数量,0 as 本月发货数量,0 as 上月发货数量,基本单位数量 as 现时库存数量 from [现时库存$])A1,

(select 物料长编码,物料名称,订单数量 from [排产计划$])A2

where A1.物料长代码=A2.物料长编码 and A1.物料名称=A2.物料名称

penghaifeng

select A1.*,A2.订单数量 from   

(select 物料长代码,物料名称,规格型号,实收数量 as 上月入库数量,0 as 本月入库数量,0 as 上月发货数量,0 as 本月发货数量,0 as 库存数量 from [上月入库数量$] union all  
select 物料长代码,物料名称,规格型号,0 as 上月入库数量,实收数量 as 本月入库数量,0 as 上月发货数量,0 as 本月发货数量,0 as 库存数量 from [本月入库数量$] union all  
select 物料长代码,物料名称,规格型号,0 as 上月入库数量,0 as 本月入库数量,基本单位调拨数量 as 上月发货数量,0 as 本月发货数量,0 as 库存数量 from [上月发货数量$] union all  select 物料长代码,物料名称,规格型号,0 as 上月入库数量,0 as 本月入库数量,0 as 上月发货数量,基本单位调拨数量 as 本月发货数量,0 as 库存数量 from [本月发货数量$] union all  select 物料长代码,物料名称,规格型号,0 as 上月入库数量,0 as 本月入库数量,0 as 上月发货数量,0 as 本月发货数量,基本单位数量 as 库存数量 from [现时库存$])A1,  

(select 物料长编码,物料名称,订单数量 from [排产计划$])A2

where A1.物料长代码=A2.物料长编码 and A1.物料名称=A2.物料名称

仔细对比一下，这是正确的语句哦！~~~

wuxiang_123

重复发帖

w112411538

不是 是吧问题全部总结后 在求助

w112411538

原帖由 penghaifeng 于 2010-7-24 11:42 发表


仔细对比一下，这是正确的语句哦！~~~

高手出现了

w112411538

penghaifeng  高手   

  问题已解决 可以结贴  最后还是要谢谢大家

100米跳远

佩服3楼老师！