>>Doing a SELECT-distinct with a UNION or an INDEX Unique on APPENDed tables is simple enough....
>>
>>.... BUT ....
>>
>>The removed duplicates should be evenly distributed amongst the 4 origins! So that makes it a lot more complex...
>>
>>
>What do you mean by removed duplicates distributed evenly among original?
>
>Do you mean that you should know in which table to keep the only correct record?
>
>E.g. say, you have
>"Lennert Blom" in all 4 tables (and may be even repeatedly in some of them)
>
>In addition to creating the 5th table with only one correct set of records (no duplicates) you want to clean up the original tables to keep only unique records in them (e.g. leave only one Lennert Blom in one of the tables by some algorithm?)
>
>Did I get right your idea?
If yes, you may have to calculate relative weight (or what's the right term? "удельный вес" in Russian) of each duplicate to the total number of records removed from each particular table...
Anyway, let's see, if this is the exact problem you're trying to solve, because now I can see the complexity.
If it's not broken, fix it until it is.
My Blog