Sorry I wasn't very clear I ment that to group by something you must add the
values, for example.

If p2 and p3 are numeric, you can put group by sum(p2), sum(p3) it will work
tha t the results will be

P1 sum of values that are related with p1
P2 sum of values that are related with p2
.....

otherwise use order by


Diego Menin
DBA - DM2/Brasil
www.cartonline.com.br

----- Original Message -----
From: "Diego - DM2" <diego@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, July 24, 2003 2:11 PM
Subject: Re: [firebird-support] GROUP BY


> If you put group by(p2) or avg (p2) and same with p3 , i guess it will
work!
>
> Diego Menin
> DBA - DM2/Brasil
> www.cartonline.com.br
>
> ----- Original Message -----
> From: "grat007" <grat@...>
> To: <firebird-support@yahoogroups.com>
> Sent: Thursday, July 24, 2003 9:24 AM
> Subject: [firebird-support] GROUP BY
>
>
> > Hi,
> > i have question, is possible this query?
> >
> > SELECT P1,P2,P3 FROM TAB1 GROUP BY P1
> >
> > Firebird MSG:
> >
> > Invalid token.
> > Dynamic SQL Error.
> > SQL error code = -104.
> > invalid column reference.
> >
> > FB 1.5 RC4, W2K
> >
> > Thanks Milan
> > (sorry my english)
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>