Create a view from table then you can use "group by" as you want.

Luiz.

----- Original Message -----
From: "Nelli" <paolo_fainelli@...>
Newsgroups: egroups.ib-support
To: <ib-support@yahoogroups.com>
Sent: Thursday, June 14, 2001 8:14 PM
Subject: [ib-support] question on group by


> Hi,
> I need to write a query from a simple table ( item, qty, selling date ).
> The result should be the sum of qty group by the month of selling date.
> Group by seems working only on field names ( i can't do a "group by 1,2,3"
> or "group by (extract month from selling date) ) .
> Any idea??
> Thanks in advance...
> Paolo
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>