UPDATE B

UPDATE ASET A.Class = B.Class ,A.[Division] = B.[Division],A.[RouteNo] = B.[RouteNo],A.[PickUpPoint] = B.[PickUpPoint],A.[DropRouteNo] = B.[DropRouteNo],A

.[DropDownPoint] = B.[DropDownPoint]FROM DailyAttendanceTable A JOIN SCHULE_STUDENTDETAILS BON A.StudentId = B.StudentId