NX1.01: Cast with Group By Error

Hello,

Reading closed issues for NX1.01 I thought this was resolved, but:

SELECT Cidade, CAST(SUM(Custo) AS Money) AS custo
FROM Chamada
GROUP BY cidade

will give error msg: "Non agreggate column ... must appear in group by"

Joao Borges
Brazil

forgot to specify that field Cidade is a Nullstring[50] and Custo is a
Extended

Per,

> Why do you need this? How about
>
> SELECT Cidade, SUM(CAST(Custo) AS Money) AS custo
> FROM Chamada
> GROUP BY cidade
>
> ?
>
> - Per

This works ! ... my mistake,

Thank you,

Joao.

Joao,

Why do you need this? How about

SELECT Cidade, SUM(CAST(Custo) AS Money) AS custo
FROM Chamada
GROUP BY cidade

?

- Per

"Joao Borges" <suporte@cybermgr.com> wrote in message
news:3f859ef3@wic040d....
> Hello,
>
> Reading closed issues for NX1.01 I thought this was resolved, but:
>
> SELECT Cidade, CAST(SUM(Custo) AS Money) AS custo
> FROM Chamada
> GROUP BY cidade
>
> will give error msg: "Non agreggate column ... must appear in group by"
>
> Joao Borges
> Brazil
>