Definition of a View Table like students prevents operation UPDATE on person table [closed]

students as view which is related To person Table

UPDATE persons
SET persons.EN_FAMILY = 'Test'
WHERE persons.STCODE IN
(SELECT students.PERSONS_STCODE AS STCODE
FROM students
WHERE @Counter > 0
AND students.ID NOT IN
(SELECT sel_lesson.ST_ID
FROM sel_lesson
WHERE sel_lesson.YEAR = @CurrenYear
AND sel_lesson.TERM = @CurrentTerm
GROUP BY sel_lesson.ST_ID)
AND students.STATUS IN('1','14')
);


Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer
1

Try use an inner join

UPDATE persons
INNER JOIN (SELECT students.PERSONS_STCODE AS STCODE
FROM students
WHERE @Counter > 0
AND students.ID NOT IN
(SELECT sel_lesson.ST_ID
FROM sel_lesson
WHERE sel_lesson.YEAR = @CurrenYear
AND sel_lesson.TERM = @CurrentTerm
GROUP BY sel_lesson.ST_ID)
AND students.STATUS IN('1','14') ) T on t.STCODE = persons.STCODE

SET persons.EN_FAMILY = 'Test'