3.自连接

案例：查询员工名和上级的名称
SELECT
e.employee_id,e.last_name AS 员工,m.employee_id,m.last_name AS 领导
FROM
employees AS e,employees AS m
WHERE
e.manager_id = m.employee_id;