SELECT
    LA.DISTRICT_CODE CODE,
    D.DISTRICT_NAME NAME,
    LA.LATITUDE LAT,
    LA.LONGITUDE LON
FROM LOCATION_TBL LA
LEFT OUTER JOIN DISTRICT D
ON LA.DISTRICT_CODE = D.DISTRICT_CODE
CROSS JOIN LOCATION_TBL LB
ON LA.DISTRICT_CODE <> '1101' AND LB.DISTRICT_CODE = '1101'
WHERE LA.DISTRICT_CODE <> '1101'
ORDER BY (
    (LA.LATITUDE - LB.LATITUDE) * (LA.LATITUDE - LB.LATITUDE) + 
    (LA.LONGITUDE - LB.LONGITUDE) * (LA.LONGITUDE - LB.LONGITUDE)
) DESC, LA.DISTRICT_CODE ASC;