Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excluding almost duplicates from a UNION
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00524751
Message ID:
00525375
Vues:
23
Maybe I am just not getting the problem. Anyway, I am glad you found and answer for it.

>>>It's not meaningless to me. It tells me which file the record came from, which was the whole point of adding it.
>
>>Yes, it does mean something if you don't remove duplicates. However, if there is a duplicate (one with "C" and one with "H") and you show only one (i.e. you remove the duplicate) then you won't be able to tell which file the record came from, will you?
>
>Sure I will. If it has a "C", it came from the current file and has an "H", it came from the history file. Removing the duplicate doesn't change the letter attached to the record.
>
>Michelle
Hector Correa
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform