合并表后结果为零

sc13988

select * from (select 供应单位,物资名称,合同号码,计量单位,规格型号,单价 as 合同单价 , 0 as 结算单价,数量 as 合同量, 0 as 结算量, 金额 as 合同金额, 0 as 结算金额 from [合同$a1:k] union all select 供应单位,物资名称,合同号码,计量单位,规格型号,单价 as 结算单价, 0 as 合同单价, 0 as 合同量,数量 as 结算量, 金额 as 结算金额, 0 as 合同金额  from [数据$a1:k])
无论怎么调整都显示为零，请教大师查看一下，谢谢！！！

sc13988

没有大亨支招了吗