Re: SQL: Update a field with the value of another

[Bill <brobins3d@xxxxxxxxx>]

Peter Vidal wrote:
> 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)

Update trdata a
	Set hdept =
	(Select b.hdept
		From Empmas b
		Where a.empno=b.empno)
	Where exists
	(Select b.hdept
		From Empmas
		Where a.empno=b.empno)

Bill