22,210
社区成员
发帖
与我相关
我的任务
分享
declare @class as int
select @class = n.class from class m , student n where m.cid = n.class and m.cstate <> '毕业'
delete from student where sid = @class
delete from class where cid = @class
DELETE A FROM STUDENT A, CLASS B WHERE A.CLASS=B.CID AND B.CSTATE='毕业'
DELETE CLASS WHERE CSTATE='毕业'