Re: Update One File from Another with SQL

[Tommy.Holden@xxxxxxxxxxxxxxxxxxxxx]

Update file2 b set b.dtsuc = coalesce(select a.ucdef from file1 a where 
a.ucdef > 0 and b.stduc = 0 and a.itnbr=b.itnbr),b.stduc)

Thanks,
Tommy Holden



From:   "Bob Voltz" <bob.voltz@xxxxxxxxxx>
To:     <midrange-l@xxxxxxxxxxxx>
Date:   09/24/2010 10:07 AM
Subject:        Update One File from Another with SQL
Sent by:        midrange-l-bounces@xxxxxxxxxxxx



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