In the one-to-many merge illustration, we had multiple observations for the same BY group in dataset C. In a many-to-many merge situation, we can end up with multiple observations for the same BY group in different datasets. Let's use the same program we used in the one-to-many merging but with slightly modified datasets:
The merged output is as follows:
The merge was performed successfully as per the LOG. However, the output is incorrect in many ways. The following are a few lines of the LOG:
NOTE: MERGE statement has ...