Mensaje
De
18/07/2003 18:18:46
a
18/07/2003 16:45:00
General information
Foro:
Visual FoxPro
Category:
Programación, sintáxis y comandos
Título:
Miscellaneous
ID de la conversación:
00811460
ID del mensaje:
00811709
Views:
15
The rules are that either a column is an aggregate column, meaning it is involved in a Sum, Max, Min...etc, or it is listed in the Group By clause.
Jay has given you several options. I personally prefer the method of Maxing the columns you don't care about (ex. Select Max(LName)).
PF
>All I am trying to do is run a query that group by a particular field with this new sintax?
>
>Any suggestions?
(On an infant's shirt): Already smarter than Bush
Jay has given you several options. I personally prefer the method of Maxing the columns you don't care about (ex. Select Max(LName)).
PF
>All I am trying to do is run a query that group by a particular field with this new sintax?
>
>Any suggestions?
(On an infant's shirt): Already smarter than Bush