Lynn Harris
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.
One example:
update cempmst set emp1='000000',amt=0
from cempmst a, cnewemp b
where nwcemp=emp
Thank You.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks again.