How to copy one column into another in DB2 sql

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • AmrutaR
    New Member
    • Oct 2017
    • 1

    How to copy one column into another in DB2 sql

    How to copy one column into another column using SQL

    SELECT DISTINCT T1.PROJECT_NAME ,
    T1.REFERENCE_ID ,
    T1.NAME AS URL1_title,
    T1.URL AS URL1,
    T1.REQUEST_TYPE ,
    T2.VAL,
    T3.VAL AS VAL1
    FROM RIDW.VW_REQUEST T1
    LEFT OUTER JOIN RICALM.VW_RQST_ STRING_EXT T2
    ON T2.REQUEST_ID=T 1.REQUEST_ID AND T2.NAME='owner_ 1'
    LEFT OUTER JOIN RICALM.VW_RQST_ STRING_EXT T3
    ON T3.REQUEST_ID=T 1.REQUEST_ID AND T3.NAME='owner_ 2'
    WHERE T1.PROJECT_ID = 0 AND
    ( T1.REQUEST_TYPE = 'Task'
    ) AND
    (T1.ISSOFTDELET ED = 0) AND
    (T1.REQUEST_ID <> -1 AND T1.REQUEST_ID IS NOT NULL)

    Here is my sql query I want to copy owner_2 col into owner_1 col

    there are two column here owner_1 and owner_2, I want to copy all contents from owner_2 to owner_1

    owner1 owner2

    | ABC| |ABC|

    |PQR | |LMN|

    output- totalowner

    |ABC|

    |PQR|

    |ABC|

    |LMN|

    how can I do it using DB2 query?
Working...