Fusionar 2 tablas con clausula UNION y agrupar el resultado - access2003 es posible?

[franko1809]

al final solucione asi

Código:

SELECT codemp, sum(BAR)
FROM (
           SELECT codemp,totalfinal AS BAR FROM Factura
           UNION ALL
           SELECT codemp,total AS BAR FROM Boleta
          )
          AS A
GROUP BY codemp