Mike Yearwood
Toronto, Ontario, Canada
Hi Steve.
You're forgiven.
As to the query, you're correct. Adding extra1 to the group results in 4 records. Leaving it out of the group by will give one record, but how does the computer know what is the "correct" result for the field extra1?
>Please forgive me, I don't have VFP8 yet. Simply adding extra1 to the group causes the query to return 4 records, correct? That's really not an acceptable end result for this type of query.
>
>>
>>In VFP 8 you would have to include extra1 in the group by because the result for extra1 is not clearly known to the computer. All values from extra1 appear to IMO remind you to think about which one you wanted.
>>
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement