DELETE FROM
    EMP_INVALID AS EI
WHERE
    EI.VALID_FLG IN (
        SELECT
            E.VALID_FLG
        FROM
            EMP AS E
    );