Sql92仅支持 内连接
Sql99支持 内连接、外连接、交叉连接
同一种查询两者语法不同,例如
内连接:
sql92
select last_name,department_name
from employees e, departments d
where e.department_id = d.department_id;
sql99 (inner可以省略)
select last_name,department_name
from employees e 【inner】 join departments d
on e.department_id = d.department_id;