AccountID for 1 and AccountID for 2 should belong to the same Account. What would be the easiest way to update AccountID of 1 and 2 to AccountID of 3? The above scenario is when the Acount Number changed once. It can actually change multiple times over a period of time.