× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. April 2008

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

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

As an Amazon Associate we earn from qualifying purchases.

This thread ...
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.