1、内连接–等值连接
自然连接,两个表相匹配的行才在结果集中出现
Select 内容 from 表1 inner join 表2 on 等值条件
Select * from student inner join grade on grade.stuid = student.stuid;
2、外连接
左连接:select 内容 from 表1 left outer join 表2 on 等值条件
右连接:select 内容 from 表1 right outer join 表2 on 等值条件
左连接按左表内容全部显示,右表数据无关联则显示null
右连接按右表内容全部显示,左表数据无关联则显示null
Select * from student right outer join grade on student.stuid = grade.stuid;
3、多表关联
Select 内容 from 表1,表2,表3 where 条件
Select * from student,course,grade where student.stuid = grade.stuid and course.couid = grade.couid and coursegrade > 80;
Select avg(coursegrade) from student,grade where student.stuid =grade.stuid and sex =’男’ and coursegrade is not null;