DELETE FROM EMP AS E
    WHERE 
    E.EMP_CODE =(
                SELECT
                    EMP_CODE
                FROM
                    EMP_INVALID
                WHERE
                    VALID_FLG = 0
                )