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 ?

Thanks for help.

Fabrice Vende
fabrice@...

-
SARL I N F O C O B
Developpement, formation, matériel, logiciel
http://www.infocob.com