SELECT
  E1.EMP_CODE AS CODE
  , E2.EMP_LAST_NAME AS SURNAME
  , E2.EMP_FIRST_NAME AS NAME 
FROM
  EMP AS E1 JOIN EMP AS E2 
    ON E1.EMP_LAST_NAME != E2.EMP_LAST_NAME 
    AND E1.EMP_FIRST_NAME != E2.EMP_FIRST_NAME 
    AND E1.EMP_KANA_NAME = E2.EMP_KANA_NAME 
WHERE
  E1.VALID_FLG = '1' 
ORDER BY
  replace (E1.EMP_LAST_NAME, ' ', '')
  , replace (E1.EMP_FIRST_NAME, ' ', '')
  , E1.EMP_CODE;