i would like to use sql statement to update one column in the table
with the values from another table, is there anyway to do it? or use
db2 utility tool? we are using db2 udb v8.1 on windows , thanks

<db2group88@yahoo.com> wrote in message
news:111e249e.0407271249.605b7790@posting.google.c om...[color=blue]
> i would like to use sql statement to update one column in the table
> with the values from another table, is there anyway to do it? or use
> db2 utility tool? we are using db2 udb v8.1 on windows , thanks
>[/color]
Here is an example from the SQL Reference manual:

UPDATE EMPLOYEE EU
SET (EU.SALARY, EU.COMM)
=
(SELECT AVG(ES.SALARY), AVG(ES.COMM)
FROM EMPLOYEE ES
WHERE ES.WORKDEPT = EU.WORKDEPT)
WHERE EU.EMPNO = '000120'

You can download all the DB2 manuals in PDF format for free from the IBM
website:
http://www-306.ibm.com/cgi-bin/db2ww...bs.d2w/en_main