Merging two Table Records

Merging two Table Records

Hi guys,
some times we need to merge two records within one line of the table,
so to do this you can use the following code, here, for example, I am using VendTabel and try to merge two vendors whose a/c no is 5001 and 5002 within 5001.

//we will explore how to correct such a situation by merging two records including
//all their related transactions. For the demonstration, we will merge two vendor accounts 5001
//and 5002 into a single one, that is, 5001.



Be Careful to use this job/Query coz it directly effect your data base