MySQL错误1443的解决方法

显然，您的视图必须包含要从中删除的表。这表明外部联接：

DELETe s   FROM student s LEFT JOIN        viewroom vr        ON vr.stud_no = s.stud_no LEFT JOIN        viewlateststudentnr vlnr        ON s.stud_no = vlnr.stud_no AND vlnr.status = '/confirm/ied'   WHERe SUBSTr(s.stud_no, 1, 4) = 1234 AND         vr.stud_no IS NULL AND vlnr.stud_no IS NULL;