Hi John,
I'm guessing that your sum is different for each row. Union will only eliminate rows that are
completely identical.
>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?
kenweber
GCom2 Solutions
Microsoft Certified Professional