select * from dept where deptno not in (select deptno from emp where job='SALESMAN' and deptno is not null);