mysql - 在外部查询中显示department_name - sql

Question

我有这个查询

select last_name,job_id,department_id
from empl_demo
where (department_id) in 
(select department_id
from departments
where department_id=60);

我的问题是如何显示部门表中的“department_name”？例如:

select last_name,job_id,department_id,department_name
from empl_demo, departments;

但要符合我的条件

谢谢

Answer 1

经典的 INNER Join，您确实需要阅读一些基础 SQL 类(class)(例如 https://www.w3schools.com/sql/ )。

SELECT e_d.last_name,
   e_d.job_id,
  e_d.department_id,
  d.department_name
FROM empl_demo e_d
INNER JOIN departments d on d.department_id = e_d.department_id
where department_id=60