Urgent help needed!!

[LKBrwn_DBA]

Try something like this:

update A_Table u
set item_nbr = (
select new_item_nbr from item_xref x
where x.item_nbr = u.item_nbr)
where exists (
select 1 from item_xref x
where x.item_nbr = u.item_nbr);