多表查询与子查询

select stu.,sc. from stu,sc where stu.sno=sc.sno

select * from stu
select * from sc

select * from cou
select sname from stu,sc where stu.sno = sc.sno and sc.cno=‘20201’

select stu.,sc.,ctime from stu,sc,cou where stu.sno = sc.sno and sc.cno=cou.cno

select stu.,sc. from stu left outer join sc on stu.sno=sc.sno

select stu.,sc. from stu left outer join sc on stu.sno = sc.sno

select mno,count(sno) as num from stu group by mno having mno between 1 and 4

insert into major values(5,‘电竞’)

select major.mno,count(sno) from major left outer join stu on major.mno = stu.mno group by major.mno

—子查询 用in 可以返回多个值 = 返回一个值