DELETE FROM 
    EMP
WHERE
    EMP_CODE IN(SELECT 
                    E.EMP_CODE
                FROM
                    EMP E    
                    INNER JOIN 
                        EMP_INVALID EI
                    ON E.EMP_CODE = EI.EMP_CODE
                )
;