DELETE FROM EMP
    WHERE EMP_CODE IN (
        SELECT
            ei.EMP_CODE
        FROM EMP_INVALID ei
        LEFT OUTER JOIN EMP e
            ON ei.EMP_CODE = e.EMP_CODE
        WHERE
            e.VALID_FLG != '1'
    );