select eno,ename
from   employees
where  eno = 1027 and not exists (
         select e.eno
         from   employees e, orders o, customers c
         where  e.zip = c.zip and
                e.eno = o.eno and
                c.cno = o.cno);

