新建 文本文档 (5).txt

来自「一个数据库SQL语言」· 文本 代码 · 共 29 行

delete    
from students   
where studentname='Joe Adams'   
   
delete    
from enrolls   
where enrolls.student=   
     (select  enrolls.student   
      from students,enrolls   
      where students.student=enrolls.student and studentname='Joe Adams')  

delete  
from students 
where studentname='Joe Adams' 
 
delete  
from enrolls 
where enrolls.student= 
     (select  enrolls.student 
      from students,enrolls 
      where students.student=enrolls.student and studentname='Joe Adams')