> What is the cleanest method to test for records that have the same ID and combind them.
>
> Ex
>
> account# Address Item1 Item2 Total
>
> 7077 Address 5.00 0.00 5.00
> 7077 Address 0.00 5.00 5.00
>
>
> and make it
>
> 7077 Address 5.00 5.00 10.00
>
>
>
>
>
> Ryan J. Lashway
> http://www.lashtech.com

select account, max(adress) as address, ;
 sum(item1) as item1, ;
 sum(item2) as item1, ;
 sum(total) as total ;
 from myTable ;
 group by 1

Cetin Basoz