UPDATE dbo.Interest SET Inter_KnotInterDate=b.perdel_delidate FROM perder b WHERE b.perdel_houseid=inter_houseid