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/
>
>
>