/*select em.emp_no emp_no,birth_date,first_name,last_name,gender,hire_date
from employees em left join dept_emp de on em.emp_no=de.emp_no
where dept_no is null */ #no exists


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