>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 it's not broken, fix it until it is.
My Blog