Try This............. Defiantly you will get your Solution..
Update student set student.HobbiesId=Hobbies.HobbiesId From student inner join Hobbies on student.HobbiesId=Hobbies.HobbiesId
Note: If this Solve your Problem Please click on Accept Answer.
Thanks
AARIF SHAIKH