• I did't try testing this but would this be what you want?

    UPDATE Table_B

    SET tree = 'Middle East',

    [entry] = 5

    FROM Table_B

    WHERE job_number in (SELECT job_number

    FROM Table_B

    WHERE tree = 'Egypt'

    GROUP BY job_number)

    -------------------------------------------------------------
    we travel not to escape life but for life not to escape us
    Don't fear failure, fear regret.