显然,您的视图必须包含要从中删除的表。这表明外部联接:
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 = 'confirmed'
WHERE SUBSTR(s.stud_no, 1, 4) = 1234 AND
vr.stud_no IS NULL AND vlnr.stud_no IS NULL;
@H_404_4@