delete student,sc,stu 
    from student left join sc on student.sno = sc.sno 
                left join stu on sc.sno = stu.sno
                where student.sname = ‘张三‘;