>>>>>>It's invalid query because "MyTable.MyField" isn't either aggregate function nor it's included in the GROUP BY.
>>>>>>
>>>>>
>>>>>I changed the SQL Select, making Group By "1,2" (instead of just 2) and it works now.
>>>>>
>>
>>But it is different.
>>
>
>Fabio,
>
>You are saying that change Group By from 2 to 1,2 changes the result of the SQL Select, right? If so, I understand and agree. But it makes the SQL Select work without giving me the error. Also, since both 1 and 2 point to the same field (2 being just an upper case version of it), I don't think it changes the result, really.
>
>Unless I am missing something, which would not surprise me <g>.
CREATE CURSOR BYBY (AA C)
INSERT INTO BYBY VALUES ('a')
INSERT INTO BYBY VALUES ('A')
SET ENGINEBEHAVIOR 70
SELECT AA,UPPER(AA) FROM BYBY GROUP BY 2
SELECT AA,UPPER(AA) FROM BYBY GROUP BY 1,2