Ramone,

Try doing your UNION in a view, then create a second view that does a SUM from your first view.

HTH,
Kurt