select '在线面积' as tbname,(case when year(日期)=2018 and month(日期)=11 and day(日期)=1 then 在线面积 else 0 end) as '1'... from 表1
union all
select '投入面积' as tbname,(case when year(日期)=2018 and month(日期)=11 and day(日期)=1 then 在线面积 else 0 end). as '1'.. from 表2
union all
select '领料金额' as tbname,(case when year(日期)=2018 and month(日期)=11 and day(日期)=1 then 在线面积 else 0 end) as '1'... from 表3
union all
select '报废面积' as tbname,(case when year(日期)=2018 and month(日期)=11 and day(日期)=1 then 在线面积 else 0 end) as '1'... from 表4
union all
select '产出面积' as tbname,(case when year(日期)=2018 and month(日期)=11 and day(日期)=1 then 在线面积 else 0 end) as '1'... from 表5