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_TBL.LONGITUDE) * (LOCATION_TBL.LATITUDE - LOCATION_TBL.LONGITUDE)
    +
    (LOCATION_1101.LATITUDE - LOCATION_1101.LONGITUDE) * (LOCATION_1101.LATITUDE - LOCATION_1101.LONGITUDE)
  ) desc,
  DISTRICT.DISTRICT_CODE asc