Georges,

This does not work, FB 'pretends' he never heard of monthtransactiondate

:(

--- In ib-support@y..., "Boutwell, George" <gboutwel@v...> wrote:
> I'm not positive it would work, but you could try:
>
> select extract(month from sales_transaction.transaction_date) as
monthtransactiondate, count(*)
> from sales_transaction
> Group By monthtransactiondate
>
> HTH,
> George
>
> On 25 Feb 2002 at 23:26, didiergm wrote:
>
> > Select extract (month from sales_transaction.transaction_date),
count(*)
> > from sales_transaction Group by extract(month from transaction_date)
> >
> > But I receive a complaint on line three any ideas ?
> >
> > Didier
> >
> >
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> >
> >