RE: Update a field with the value of another

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

UPDATE trdata a SET hdept = 
  (SELECT b.hdept 
   FROM empmas b
   WHERE a.empno = b.empno)
WHERE EXISTS 
  (SELECT b.hdept 
   FROM empmas b
   WHERE a.empno = b.empno)

Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i5/OS and OS/400
www.centerfieldtechnology.com
 

-----Original Message-----
Subject: SQL: Update a field with the value of another

Hi list:

This is a silly question but comes from somebody who is a novice.  I have to
update a field (HDEPT) in a file (TRDATA) with the with the value of a field
(also HDEPT) that resides in another file (EMPMAS).  My key field is the
employee number (EMPNO)

How will the SQL statement will look like?

TIA (a lot!)

PETER VIDAL