select "期初",规格型号,机器号,数量,0 as 数量3, 0 as 数量2, 金额,0 as 金额3, 0 as 金额2 from [期初$] union all select "入库",规格型号,机器号, 0 as 数量2, 数量,0 as 数量3, 0 as 金额2, 金额,0 as 金额3 from [入库$] union all select "出库",规格型号,机器号, 0 as 数量3, 0 as 数量2,数量, 0 as 金额3, 0 as 金额2,金额 from [出库$] 注意上色的位置,因为三个源数据表里面是没有同时存在你需要的字段的,所以会对没有的字段进行0替代,产生数据列的变化以满足联合查询的列数必须相等的条件 |