SELECT
	t1.CODE
	,t1.SURNAME
	,t1.NAME
FROM
	(
	SELECT
	    EMP_CODE AS CODE
	    ,EMP_LAST_NAME AS SURNAME
	    ,EMP_FIRST_NAME AS NAME
		,REPLACE(EMP_LAST_NAME,' ','') AS hanSURNAME
		,REPLACE(EMP_FIRST_NAME,' ','') AS hanNAME
		,EMP_KANA_NAME AS seimei
	FROM EMP
	WHERE VALID_FLG = '1'
	) AS t1
CROSS JOIN
	(
	SELECT
	    EMP_CODE AS CODE
		,REPLACE(EMP_LAST_NAME,' ','') AS hanSURNAME
		,REPLACE(EMP_FIRST_NAME,' ','') AS hanNAME
	FROM EMP
	WHERE VALID_FLG = '1'
	) AS t2
WHERE t1.CODE <> t2.CODE
	AND t1.hanSURNAME = t2.hanSURNAME
	AND t1.hanNAME = t2.hanNAME
ORDER BY t1.seimei,t1.CODE