DELETE 
FROM
	EMP 
WHERE
	EXISTS ( 
		SELECT
			  1 
		FROM
			EMP_INVALID 
		WHERE
			EMP.EMP_CODE = EMP_INVALID.EMP_CODE 
			AND emp.VALID_FLG = '0'
	) 
;