insert into nopass select * from student where 学号 in(select 学号 from where 成绩<60)
insert into noPass select student.* from ,student where .sno=student.sno and .s<60
INSERT INTO noPass Select student.* from student INNER JOIN ON student.Sno= .Sno where .SMark<60
1: Select a.* from student a join b on a.Sno = b.Sno where b.S<60 2: Select * from student where Sno in (select Sno from where SMark<60)看到有贴子说in子查询比join 效率要高。
insert into noPass select A.* from student A, B where A.Sno=B.Sno and B.SMark<60
1: insert nopass Select a.* from student a join b on a.Sno = b.Sno where b.S<60 2: insert nopass Select * from student where Sno in (select Sno from where SMark<60)
insert into nopass select s.sno,sname from student s join m on s.sno=m.sname and s<60
from ,student
where .sno=student.sno and .s<60
Select student.*
from student INNER JOIN ON student.Sno= .Sno
where .SMark<60
Select a.* from student a join b on a.Sno = b.Sno
where b.S<60
2:
Select * from student where Sno in (select Sno from where SMark<60)看到有贴子说in子查询比join 效率要高。
insert nopass
Select a.* from student a join b on a.Sno = b.Sno
where b.S<60
2:
insert nopass
Select * from student where Sno in (select Sno from where SMark<60)
select s.sno,sname
from student s join m
on s.sno=m.sname
and s<60