Dear All,

Thanks for your valuable help

Here is the changed Query ....

UPDATE TEST1

SET TEST1.INT_TBL_CODE = T2.INT_TBL_CODE,

TEST1.CUST_CR_PREF_PCNT =T2.CUST_CR_PREF_PCNT,

TEST1.ID_CR_PREF_PCNT =T2.ID_CR_PREF_PCNT ,

TEST1.ID_DR_PREF_PCNT =T2.ID_DR_PREF_PCNT ,

TEST1.MIN_INT_PCNT_CR=T2.MIN_INT_PCNT_CR,

TEST1.MAX_INT_PCNT_CR =T2.MAX_INT_PCNT_CR,

TEST1.END_DATE =T2.END_DATE,

TEST1.PEGGED_FLG = T2.PEGGED_FLG,

TEST1.INT_TBL_VER_NUM =...