oracle中将三个没有关系的表的字段再同一个表中显示 union all

 select sum(SQYDMJ) as SQYDMJ,sum(ZHDZMJ) as ZHDZMJ,sum(SJYDMJ) as SJYDMJ ,

'批地面积      征地面积     供地面积' as ms from (

select round(sum(nvl(SQYDMJ,0)/10000),4) as SQYDMJ,0 as ZHDZMJ,0 as SJYDMJ  from JGS_JSYDBPXMXX
 where to_char(XMPZSJ, 'yyyy') ={1}
 or to_char(SBSPFSJ, 'yyyy')={1}
 or to_char(SBBPFSJ, 'yyyy')={1} and QHDM like '{0}%'
 union all
select 0,round(sum(nvl(ZHDZMJ,0)/10000),4) as ZHDZMJ ,0 from JGS_ZHDXMXX
 where to_char(ZHDWCSJ, 'yyyy')={1} and QHDM like '{0}%'
 union all
 select 0,0,round(sum(nvl(SJYDMJ,0)/10000),4)  as SJYDMJ
from jgs_tdgy
 where to_char(PZSJ, 'yyyy')={1}  and QHDM like '{0}%'

)    

绿色括号中的值为

整体的值为