When I issue a SQL-Select like the following:

select Field1, sum(Field2) from Table;
where Field3 ! = "XXX";
union select Field1, sum(Field2) from Table2;
where Field3 ! = "XXX";
group by Field1


The result table will consistantly contain one record for each Field1 value except for one duplicate.

Does anyone know how to get no duplicates?