Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Excluding almost duplicates from a UNION
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00524751
Message ID:
00525375
Views:
22
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform