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