There is an example that:
merge two records A and B to one record C, which has the same key with record A.
Will record A and B be deleted?
If it is customer master data, how to make sure my sales orders for A and B change to C, and all other tables related to A an B will be changed too?