I did your test. I got the same result as you. But I wonder about the presence of the "1 Val 1" in the final result? It's the same in both side, nothing different between test and test1 for this record. The union is not suppose to retain only the different records?