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