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