myql如何查询有外键的表，实现多表联查？

举例子

create table t_departments(
    id int primary key auto_increment,
    name varchar(50),
    location varchar(128)
)default charset = utf8;

create table t_employees(
    id int primary key auto_increment,
    name varchar(64),
    salary double,
    dept_id int,
    foreign key (dept_id) references t_departments(id)
)default charset = utf8;

这里有两张表，第二张表设置了外键
查询这个department部门中有几个员工

select t_departments.id,t_departments.name,t_departments.location,
       t_employees.id emp_id,t_employees.name emp_name,t_employees.salary
from t_departments join t_employees
    on t_departments.id = t_employees.dept_id
where t_departments.id = 1;

查询结果

显然是查到了这个部门下，所有的员工

数据信息