Access the answers to your technology questions today.
Subscribe Now
30-day free trial. Register in 60 seconds.
What Makes Experts Exchange Unique?
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
Subscribe Now
30-day free trial. Register in 60 seconds.
Join the Community
Give a Little. Get a Lot.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Join the Community
by: pcelbaPosted on 2009-04-22 at 11:29:36ID: 24207982
I am not PL/SQL expert but seems you have several rows with same ITEMNUM in inventory table. Is it right? If yes and GLACCOUNT is same for all these rows, this could work:
update invcost a
set a.glaccount = (select TOP 1 b.GLACCOUNT from inventory b
where a.ITEMNUM = b.ITEMNUM
and b.GLACCOUNT is not null)
where exists
(select 1 from inventory b
where a.ITEMNUM = b.ITEMNUM
and b.GLACCOUNT is not null )
and a.glaccount is null