I knew I forgot something, added to the where clause so you don't update to much.
UPDATE Table_B
SET tree = 'Middle East',
[entry] = 5
FROM Table_B
WHERE tree = 'Africa'
and 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.