At 03:37 PM 14/08/2010, Hardy , wrote:

>Hi Aage,
>
>My select sum(...) very simple, but yet generate error, the error message very
>strange where it is looking for the primary key
>that is not listed in the select clause
>
>for example I do the following simple select without group by.
>
>Select sum(amount) Tamt
>where region = 'West'

No FROM clause?

>Table
>Sls_id = varchar(10) primary key
>Region = varchar(20)
>Amount = Numeric(13.2)

HB.