Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
I don't know. Maybe I put it in the wrong spot? I thought maybe the group by was just applying to one of the selects and not the whole union. At any rate, it didn't eliminate the duplicates.
Thanks,
Michelle
>I have no idea why this didn't work for you - I use GROUP BY all the time; sometimes to select only a few records out of many (i.e., eliminate duplicates).
>
>Please note that Visual FoxPro might select some random record for the fields that are not unique!
>
>Hilmar.
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