DQL语言的学习（六）

DQL语言的学习（六）

六、连接查询

内连接：等值链接、非等值连接、自连接
外连接：左外连接、右外连接、全外连接（不支持）
交叉连接

（一）sql92标准

1.等值连接

select e.last_name,e.job_id,job_title
from employees e,job_id j
where e.job_id = j.job_id;

两表顺序可以调换

复杂的案例：

select department_name,d.manager_id,min(salary)
from department,employees e
where d.department_id,employees_id//多表连接，至少需要n-1个连接条件
and comission_pct is not null
group by department_name,d.manager_id
order by manager_id desc;

2.非等值连接

select salary,grade_level
from employees e,job_grades g
where salary between g.lowest_sal and g.highest_sal
and g.grade_level = 'A'

3.自连接

给表取两个别名进行连接

select employee_id,last_name,employee_id,last_name
from employees e,employee m
where e.manager_id=m.employee_id;