We are jumping from VFP 7 to 9. In running our appl to check for anomolies we are seeing issues with queries. Specifically GRoup By clauses.

I thought I read somewhere that the Group By syntax changed from 7-8 to be morew T-SQL like to where all your columns except aggregates in the query must be in the Group By clause unlike before where you only put in specific colmns. Van someone briefly enlighten me?