2-15.sql
上传用户:lyj12345cj
上传日期:2010-02-12
资源大小:600k
文件大小:0k
源码类别:

SQL Server

开发平台:

SQL

  1. delete 
  2. from students
  3. where studentname='Joe Adams'
  4. delete 
  5. from enrolls
  6. where enrolls.student=
  7.      (select  enrolls.student
  8.       from students,enrolls
  9.       where students.student=enrolls.student and studentname='Joe Adams')