初学oracle--join的整体实例说明

使用前面博客中的例子
http://blog.csdn.net/m0_37949689/article/details/79217183

1、验证inner join

select student.sno, sname, math, english, (math+english) 总成绩 
from student inner join score on student.sno=score.sno 
order by 总成绩 desc 

---

2、验证left [outer] join

select student.sno, sname, math, english, math+english 总成绩 
from student left join score on student.sno=score.sno 
order by 总成绩 desc;

注释：005 小孔的总成绩为NULL，排序时NULL按照无穷大处理。
参见http://blog.csdn.net/m0_37949689/article/details/79205386
3、验证right [outer] join

select student.sno, sname, math, english, math+english 总成绩 
from student right join score on student.sno=score.sno 
order by 总成绩 desc;

4、验证full [outer] join

select student.sno, sname, math, english, math+english 总成绩 
from student full join score on student.sno=score.sno 
order by 总成绩 desc;

---

5、验证cross join

select * from student cross join score;