关键字exists查找未分配具体部门的员工的所有信息

/*
SELECT column_name(s)
FROM table_name
WHERE EXISTS
(SELECT column_name FROM table_name WHERE condition);
*/

select * from employees
where not exists 
(select emp_no from dept_emp
 where employees.emp_no=dept_emp.emp_no)