--- In firebird-support@yahoogroups.com, "grat007" <grat@q...> wrote:

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

Milan, can't you explain what do you want to group on values of P3
and what result expect? Don't you confuse Group and Order?

> (sorry my english)

My is'nt much better ;)

Best regards, Alexander.