Link to home
Start Free TrialLog in
Avatar of Lynn Harris
Lynn HarrisFlag for United States of America

asked on

AS400 SQL update with multiple files

I would like to update fields on one file based on a join between it and an another file.  I keep getting error on my varies attempt.  (from not expected)

One example:

update cempmst set emp1='000000',amt=0  
from cempmst a, cnewemp b              
where  nwcemp=emp                      


Thank You.  
                         


ASKER CERTIFIED SOLUTION
Avatar of Gary Patterson, CISSP
Gary Patterson, CISSP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Lynn Harris

ASKER

You were correct  It work perfectly.  

Thanks again.