34,591
社区成员
发帖
与我相关
我的任务
分享
delete from StudentInfo from StudentInfo
inner join Class on Class.ClassID=StudentInfo.ClassID
inner join Major on Major.MajorID=Class.MajorID
where Major.CollegeID=?
delete StudentInfo from StudentInfo where exists(
select 1 from Class
inner join Major on Major.MajorID=Class.MajorID
where Class.ClassID=StudentInfo.ClassID and Major.CollegeID=?)
delete from StudentInfo
where StudentInfo.ClassID
in (select classid from Class A,major B where A.classid = B.majorid and B.major.collegeid?)
--StudentInfo,Class 先join啊,按照你join的顺序依次执行