SQL - sumar resultado de 2 consultas

use practicas

select CNOMBREP01,SUM(cunidades)as mesprueba from MGW10010

full join MGW10005 on (MGW10005.CIDPRODU01 = MGW10010.CIDPRODU01)

full join MGW10008 on (MGW10008.CIDDOCUM01 = MGW10010.CIDDOCUM01)

where (MGW10008.CFECHA between  '2017-01-1' and '2017-01-31')

/*and CNOMBREP01 = 'JALADERA COBRE MATE                                         '*/

group by CNOMBREP01

union all

select CNOMBREP01,SUM(cunidades)as mesprueba from MGW10010_2016

full join MGW10005 on (MGW10005.CIDPRODU01 = MGW10010_2016.CIDPRODU01)

full join MGW10008_2016 on (MGW10008_2016.CIDDOCUM01 = MGW10010_2016.CIDDOCUM01)

where (MGW10008_2016.CFECHA between  '2016-01-1' and '2016-01-31')

group by CNOMBREP01

select CNOMBREP01, sum(cunidades) mesprueba

from

(

	select

	  CNOMBREP01,cunidades

	from MGW10010

	full join MGW10005 on MGW10005.CIDPRODU01 = MGW10010.CIDPRODU01

	full join MGW10008 on MGW10008.CIDDOCUM01 = MGW10010.CIDDOCUM01

	where

	  MGW10008.CFECHA between '2017-01-1' and '2017-01-31'

	union all

	select

	  CNOMBREP01,cunidades

	from MGW10010_2016

	full join MGW10005 on MGW10005.CIDPRODU01 = MGW10010_2016.CIDPRODU01

	full join MGW10008_2016 on MGW10008_2016.CIDDOCUM01 = MGW10010_2016.CIDDOCUM01

	where

	  MGW10008_2016.CFECHA between '2016-01-1' and '2016-01-31'

) T1

group by CNOMBREP01

SELECT Tabla1.* FROM tabla1;

o

SELECT T1.* FROM Tabla1 as T1

o

SELECT T1.* FROM Tabla1 T1

o

SELECT T1.* FROM (Tabla1) T1