RE: Update One File from Another with SQL

Bob,

Update b
set b.stduc = ( select a.ucdef
from a
where a.ucdef > 0
and a.itnbr = b.itnbr )
where b.stduc = 0
and exists( select *
from a
where a.ucdef > 0
and a.itnbr = b.itnbr )

Paul

Principal Programmer Analyst
IS Supply Chain/Replenishment


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob Voltz
Sent: Friday, September 24, 2010 11:06 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Update One File from Another with SQL

I want to update File B with data from File A.

There is a one-to-one relationship based on Item Number.

Pseudocode:

IF A.UCDEF > 0 AND B.STDUC = 0 AND A.ITNBR = B.ITNBR THEN LET B.STDUC =
A.UCDEF



How is this accomplished with SQL?



Thanks,

Bob Voltz