General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>Sorry to see it change. That is one of the things I loved about VFP was it's SQL was flexible and easy to use. Oh well.
>
The problem is that when you have non-aggregated fields that aren't listed in the GROUP BY clause, you can get random results. VFP arbitrarily picks the data for the non-aggregated fields from the last record in the group, but there's nothing that makes that value correct.
In your example, it's probably not a big deal, but in some cases, you actually get wrong results.
In general, the changes that have been made to SELECT in the last few versions that make queries that previously worked fail are because those queries could return spurious results.
Tamar
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only