//会产生两张表的条数之积,简称笛卡尔积
select ename, dname from emp, dept;
//92的写法,内连接的等值连接
select
e.ename, d.dname
from emp e, dept d where e.deptno = d.deptno;
//99的写法,内连接的等值连接
select
e.ename, d.dname
from emp e
innerjoin dept d on e.deptno = d.deptno;
//SQL99语法:内连接中的非等值连接
SELECT
e.ename,
e.sal,
s.GRADE
FROM emp e
JOIN salgrade s ON e.sal BETWEEN s.LOSALAND s.HISAL;
//内连接的自连接SELECT
e.ename,
e1.ENAME boss
FROM emp e
JOIN emp e1 ON e.MGR = e1.EMPNO
//外连接的左连接
SELECT
d.dname,
e.ENAME
FROM dept d
LEFTJOIN emp e ON e.DEPTNO = d.deptno
//外连接的右连接
SELECT
e.ENAME,
d.dname
FROM emp e
RIGHTJOIN dept d ON d.deptno = e.DEPTNO