DELETE FROM EMP
WHERE
    EMP.EMP_CODE IN (SELECT
                       EMP_INVALID.EMP_CODE
                   FROM 
                       EMP_INVALID)
    and EMP.VALID_FLG = 0;