SELECT EMP1.EMP_CODE AS CODE,EMP1.EMP_LAST_NAME AS SURNAME,EMP1.EMP_FIRST_NAME AS NAME
FROM EMP AS EMP1
INNER JOIN EMP AS EMP2
	ON replace(EMP2.EMP_LAST_NAME,' ','') = replace(EMP1.EMP_LAST_NAME,' ','')
	AND replace(EMP2.EMP_FIRST_NAME,' ','') = replace(EMP1.EMP_FIRST_NAME,' ','')
WHERE 
	EMP1.VALID_FLG = 1
	AND EMP2.VALID_FLG = 1
	AND EMP2.EMP_CODE <> EMP1.EMP_CODE
ORDER BY replace((SURNAME || NAME),' ',''),CODE