Here's the first one is mapping table and the other two is from parent table.
Mapping table--here delvid needs to be updated with updvid
Parent table--if vid exists in mapping table in column delid then that needs to be updated
but the problem is if that vid already exists with same dealid,there will be the problem as
table has to be unique(vid and dealid)--in this case we will not update but delete the minimun tid.
here,here 3972197 already exists(scrren shot 3)
also 4049233 exists and needs to be updated with 4049233.
If i update there will be one more row with same dealid and vid,in this case we need to keep just minimum tid.
Please assist.Thanks in advance