DELETE FROM
    EMP_INVALID AS EI
    INNER JOIN EMP AS E ON EI.EMP_CODE = E.EMP_CODE
WHERE
    E.VALID_FLG = '0';