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