13.查询不属于开发部员工的基本信息.sql

来自「介绍了一些数据库中常用的语句」· SQL 代码 · 共 4 行

select e.empid,e.name,e.birthdate,e.salary,departments.depname as 部门
from departments INNER JOIN 
    employees as e on  departments.depid= e.department
where not(departments.depname='开发部')