DELETE FROM
    EMP AS e
WHERE
    EXISTS (
        SELECT
            *
        FROM
            EMP_INVALID AS ei
        WHERE
            e.EMP_CODE = ei.EMP_CODE
    )
;