赞
踩
union
union all
//查询10号和20号部门的员工的信息: select * from emp where deptno = 10 union select * from emp where deptno = 20; //或: select *