Hi Guys,

I tried this query and it works:

update a

set [past effective date 1] = b.effective_date , [Past Rate 1] = b.rate

from trend_analysis a inner join tempratehistory b

...

Thanks for replying.

I tried the query below

update TOP (1) s

set [past effective date 1] = s.effective_date , [Past Rate 1] = s.rate

from tempratehistory s Join trend_analysis...

MY PM TO LYNN

Hi Lynn,

This is my first post, I dont know if Im suppose to keep it on the forum. I wanted to make sure you see it.. [BigGrin]

Thanks...

That did the trick!

Thanks a million Lynn!:D