update的关联表操作

UPDATE Math_Student
SET Math_Student.StudentName=zui.改姓名,Math_Student.StudentIDCard=zui.改考生号
FROM Math_Student
JOIN zui on zui.考生号=Math_Student.StudentIDCard and Math_Student.UserId='E03352AF-1053-4ECB-BF58-B225877EA12D'
and zui.改考生号 not in (
select Math_Student.StudentIDCard from Math_Student
)