>Hi All,
> I have need of a select statement that adds certain values and returns a single record out of, for example, two records.
>
>

 1   GLOC  20228       9.33247      1.10   92.16   1    T   P   1
> 2   GLOC  17533       5.00000      1.10   92.16   1    T   P   2

>
>The select statement would preferably return
>
>

1   GLOC  20228       14.33247      1.10   92.16   1    T   P   1

select Field1, sum(Num1) as Total_Num1, sum(Num2) as Total_Num2;
  from MyTable;
  group by Field1

Several records that have the same value for Field1 will be grouped together. sum() will take care of adding the values in the required fields.

For fields that have different values, and are not summed, you can't trust that a specific value will be selected. But perhaps you can select min(pk), and then add a second SELECT statement or a subquery.

HTH, Hilmar.