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 22:52:58
Sergey Berezniker
New York, United States
 
 
To
04/10/2001 22:37:58
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:
00564606
Views:
14
>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.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform