I have two tables

1-Address_Master

IdAddress

1Puna

2UK

2-Address_Change

IdAddressDate

1agra 2015-07-16 01:02:09.160

1mathura2015-07-18 01:02:09.183

1delhi 2015-07-21 01:02:09.190

2noida 2015-07-15 01:02:09.197

2Agra 2015-07-24 01:02:09.203

And i want to update latest address from Address_Change table to Address_Master table order by date wise.

currently i am using below query, and this query is updating those records those are insert first. Please help me.

update A set A.address =C.Address

from Address_Master A

inner join Address_change C on A.id=C.id