Hi,

At July 24, 2003, 09:24, grat007 wrote:

> Hi,
> i have question, is possible this query?

> SELECT P1,P2,P3 FROM TAB1 GROUP BY P1

No. When using a GROUP BY, you have to reference all non-aggregate
fields, of the result set, in the GROUP BY clause. That is the SQL
standard.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)