Sherzy
11/11/2016 - 9:17 PM

Update with Join

Update with Join

UPDATE
    [dbo].[StudentSession]
SET
    [AttendanceRecorded] = 1
FROM
    StudentSession SS
    JOIN
    TeacherSession TS ON SS.TeacherSessionId = TS.TeacherSessionId
WHERE
    TS.TeacherSessionStatusId = 4