-- 查询研发部和销售部的员工信息,包含员工号、员工名字
select eid,ename from emp3 where dept_id in(select deptno from dept3 where name = '研发部' or name = '销售部');
MYSQL 寒假自学 2022 十一(七)
最新推荐文章于 2024-05-09 00:12:29 发布
-- 查询研发部和销售部的员工信息,包含员工号、员工名字
select eid,ename from emp3 where dept_id in(select deptno from dept3 where name = '研发部' or name = '销售部');