Updating table 1 column with table 2 column

seluri · New User Joined: 13 Jul 2006 Posts: 2

Hi
I am looking for DB2 SQL UPDATE EXAMPLE QUERY FOR UPDATE TABLE "A " column with table "B" column. I want to run this in QMF.

guptae · Posted: Thu Jul 13, 2006 11:11 am

Hi ,

You can use following query

UPDATE A
SET a = ( SELECT b
FROM B
WHERE .........')
WHERE .............;

By this query you can update coloumn a of Table A by Cloumn b of Table B.

Hanfur · Active User Joined: 21 Jun 2006 Posts: 104

Try this..

UPDATE TEST.TABLE1
SET FIRST_COL_DATE=SEC_COL_DATE

-Han

seluri · New User Joined: 13 Jul 2006 Posts: 2

thanks