Hi Frank,

Yes, in the future I think coding will be quite different for some of these statements to do just what you said. As for retrofitting older code, it is less testing to change just that part of the current SQL SELECT.

Thanks for your comment.

Albert Gostick

>Hi Albert,
>
>I think the way it should be handled is that you split the SQL into two different SQL statements. The first one will just have the primary key field and the fields being aggregated, then you join the result of that SQL with the original table to get the other fields that you want.
>