可以这样解决问题:
select 姓名,身份证号,发放资金*1 as 发放资金 from [1月$] union all
select 姓名,身份证号,发放资金*1 as 发放资金 from [2月$] union all
select 姓名,身份证号,发放资金*1 as 发放资金 from [3月$] union all
select 姓名,身份证号,发放资金*1 as 发放资金 from [4月$] union all
select 姓名,身份证号,发放资金*1 as 发放资金 from [5月$] union all
select 姓名,身份证号,发放资金*1 as 发放资金 from [6月$] union all
select 姓名,身份证号,发放资金*1 as 发放资金 from [7月$] union all
select,姓名,身份证号,发放资金*1 as 发放资金 from [8月$] union all
select 姓名,身份证号,发放资金*1 as 发放资金 from [9月$] union all
select 姓名,身份证号,发放资金*1 as 发放资金 from [10月$] union all
select 姓名,身份证号,发放资金*1 as 发放资金 from [11月$] union all
select 姓名,身份证号,发放资金*1 as 发放资金 from [12月$]
但之前做法的问题究竟出在哪里,也不晓得。 |