Urgent help needed!!

[ssmith001]

Oops...gave you the wrong query. Here's the correct one, which is still not updating any rows:

update temp_schedrcpts u
set manu_item = (
select imlitm from f4101 x
where x.imaitm = u.legacy_item)
where exists (
select 1 from f4101 x
where x.imaitm = u.legacy_item);


Steve