UPDATE MARKS
SET MARK_RECORD='0'
WHERE exists
(
select s.*, ASSESSMENT.NAME
from s left join assessment
on assessment.assessmentid=s.assessmentid
WHERE ASSESSMENT.NAME='EXAM'
)
SET MARK_RECORD='0'
WHERE exists
(
select s.*, ASSESSMENT.NAME
from s left join assessment
on assessment.assessmentid=s.assessmentid
WHERE ASSESSMENT.NAME='EXAM'
)
SET MARK_RECORD='0'
WHERE assessmentid in
(
select assessment.assessmentid from assessment
WHERE ASSESSMENT.NAME='EXAM'
)