Select cname as customer_names
from loan l join branch b1 on l.bname=b1.bname
AND cname in
(select cname
from account a join branch b2 on a.bname=b2.bname
where lower(bcity)='New York'
AND l.bname!=a.bname);