MySQL数据库连接查询的内连接

MySQL数据库连接查询的内连接

内连接（[inner] join on）

内连接的关键字是‘join’，属于sql99的语法标准。
语法：
select 字段1，字段2，…
from 表1
inner join 表2 on 连接条件;

接下来我们通过几个例子来学习一下：
例1 ：查询员工名、部门名

select last_name,department_name from departments d 
join employees e on e.`department_id`=d.`department_id`;

例2：查询有奖金的员工名、部门名

select last_name,department_name from departments d 
join employees e on e.`department_id`=d.`department_id` 
where commission_pct is not null;

例3：查询城市名、员工名和部门名

select city,last_name,department_name from employees e 
inner join departments d on e.`department_id`=d.`department_id` 
inner join locations l on l.`location_id`=d.`location_id`;