At 11:19 AM 27-09-01 +0200, you wrote:

>Hi !
>
>I have a price (st_value01), an acticle (st_article) and a date
>(st_datelibre1). And I would like to do the sum of the price group by month.
>How can I do ?
>
>Because :
>select sum(st_valeur01),st_article,extract(month from st_datelibre1)
>from statistiquefiche
>group by extract(month from st_datelibre1),st_article
>
>Don't work !!!!
>
>It is a interbase 6.0 limitation ?

Well, you could put it that way. InterBase doesn't let you group by an expression.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________