select
    D.DISTRICT_CODE as CODE
    , D.DISTRICT_NAME as NAME
    , T.LAT
    , T.LON
from DISTRICT as D
inner join (select
            L2.DISTRICT_CODE
            , L2.LATITUDE as LAT
            , L2.LONGITUDE as LON
            , pow(L1.LATITUDE - L2.LATITUDE, 2) + pow(L1.LONGITUDE - L2.LONGITUDE, 2) as DISTANCE
        from LOCATION_TBL as L1, LOCATION_TBL as L2
        where L1.DISTRICT_CODE='1101' and L2.DISTRICT_CODE<>'1101') as T
    on D.DISTRICT_CODE=T.DISTRICT_CODE
order by T.DISTANCE desc, D.DISTRICT_CODE asc
;