>>>>>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>.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham