SELECT A.customername AS CustomerName1,
       B.customername AS CustomerName2,
       A.city
FROM   customers A,
       customers B
WHERE  A.customerid <> B.customerid
       AND A.city = B.city
ORDER  BY A.city;