Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How do I UNION 2 selects and keep 1 of a duplicate recor
Message
From
04/10/2001 23:35:46
Peter Brama
West Pointe Enterprises
Detroit, Michigan, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: How do I UNION 2 selects and keep 1 of a duplicate recor
Miscellaneous
Thread ID:
00564602
Message ID:
00564610
Views:
14
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!!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform