Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How do I UNION 2 selects and keep 1 of a duplicate recor
Message
De
04/10/2001 23:35:46
Peter Brama
West Pointe Enterprises
Detroit, Michigan, États-Unis
 
 
À
04/10/2001 22:52:58
Sergey Berezniker
New York, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: How do I UNION 2 selects and keep 1 of a duplicate recor
Divers
Thread ID:
00564602
Message ID:
00564610
Vues:
15
I tried UNION but it removed both duplicates.

>>I have two selects all structurally identical. I want to merge the two selects, and any duplicate records, I want 1 kept not both removed.
>
>UNION ALL will keep all records, UNION - only one of the duplicate records. The key is the whole record.
Peter Brama
West Pointe Enterprises

VFP is getting easier but STILL alot to learn!!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform