select
  DISTRICT.DISTRICT_CODE as CODE,
  DISTRICT.DISTRICT_NAME as NAME,
  LOCATION_TBL.LATITUDE as LAT,
  LOCATION_TBL.LONGITUDE as LON
from DISTRICT
inner join LOCATION_TBL
  on  DISTRICT.DISTRICT_CODE = LOCATION_TBL.DISTRICT_CODE
  and DISTRICT.DISTRICT_CODE <> '1101'
cross join (
  select * from LOCATION_TBL where DISTRICT_CODE = '1101'
) as LOCATION_1101
order by
  SQRT(
    (LOCATION_TBL.LATITUDE  - LOCATION_1101.LATITUDE ) * (LOCATION_TBL.LATITUDE  - LOCATION_1101.LATITUDE ) +
    (LOCATION_TBL.LONGITUDE - LOCATION_1101.LONGITUDE) * (LOCATION_TBL.LONGITUDE - LOCATION_1101.LONGITUDE)
  ) desc,
  DISTRICT.DISTRICT_CODE asc