连表更新

sql="update a set a.teacher_id="&firstLessonTeacher&",a.teacher='"&getTeacherNameList(conn,firstLessonTeacher)&"',a.teacherimage=b.image1 from classset as a,Edu_Person as b 

where b.teacher_id="&firstLessonTeacher&" and a.class_id="&newClassId

转载于:https://www.cnblogs.com/jiayue360/p/3166882.html