首先构建场景
相应表中数据如下：
1 SELECT * FROM EMPLOYEE；
1 SELECT * FROM DEPTINFO;
1 SELECT E.EMPNAME, D.DEPNAME 2 FROM EMPLOYEE E, DEPTINFO D 3 WHERE E.DEPTID = D.DEPID 4 ORDER BY DEPNAME;
1 SELECT E.EMPNAME, D.DEPNAME
2 FROM EMPLOYEE E
3 JOIN DEPTINFO D
4 ON E.DEPTID = D.DEPID
5 ORDER BY DEPNAME;
原文：http://www.cnblogs.com/zhaowencong/p/4210615.html