select student_score.* from student_score,lesson
where
lesson.本学期开设='是'and
lesson.课程代号=student_score.课程代号 and
student_score.学号 like '01%'
and lesson.课程代号 like '61190%
可以选出student_score中需要的行,请问怎么将选出的这写行删除?请写出语句.
...全文
674打赏收藏
菜鸟问题!
select student_score.* from student_score,lesson where lesson.本学期开设='是'and lesson.课程代号=student_score.课程代号 and student_score.学号 like '01%' and lesson.课程代号 like '61190% 可以选出student_score中需要的行,请问怎么将选出的这写行删除?请写出语句.
delete student_score
from student_score,lesson
where
lesson.本学期开设='是'and
lesson.课程代号=student_score.课程代号 and
student_score.学号 like '01%'
and lesson.课程代号 like '61190%