举例子
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;
查询结果
显然是查到了这个部门下,所有的员工
数据信息