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}%'
)
绿色括号中的值为
整体的值为