SQL(2)多表查询

 多表查询

内容为宋红康老师SQL课程MySQL数据库教程天花板，mysql安装到mysql高级，强！硬！_哔哩哔哩_bilibili

# 多表查询
#1、查询员工名为'Abel'的人在哪个城市工作？ Oxford
SELECT department_id
FROM employees
WHERE last_name='Abel';

SELECT location_id
FROM departments
WHERE department_id=80; 

SELECT city
FROM locations
WHERE location_id=2500; 


# 2、1中查询方式复杂，其中一种改进方式如下 Oxford
SELECT loc.city
FROM employees AS emp
JOIN departments AS dep
ON emp.department_id = dep.department_id
JOIN locations AS loc
ON dep.location_id=loc.location_id
WHERE last_name='Abel';

# 1.如果有n个表实现多表的查询，则需要至少n-1个连接条件 FROM 表名,表名…… WHERE AND  或者 FROM JOIN WHERE AND 或者 FROM JOIN ON JOIN ON
# 2.如果查询语句中出现了多个表中都存在的字段，则必须指明此字段所在的表。从sql优化的角度，建议多表查询时，每个字段前