I have 2 files that are clones - created by DUPOBJ. File_A is the original. File_BU is the copy. After I finish processing File_A, I want to update the same column (tSTAdm) in File_A when it is not equal to the same column (tStAdm) in File_BU. The file has a unique key – TsStat.
I got the following code to work, but there must be a simpler code.
UPDATE File_a as T01 SET T01.tStADM = (Select T03.tStAdm from File_BU as T03 where T01.TsStat = T03.TsStat) Where T01.TsStat in (Select T02.TsStat from File_BU as T02 where T01.tStAdm <> T02.tStAdm) Phil