473,322 Members | 1,405 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

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=T1.REQUEST_ID AND T2.NAME='owner_1'
LEFT OUTER JOIN RICALM.VW_RQST_STRING_EXT T3
ON T3.REQUEST_ID=T1.REQUEST_ID AND T3.NAME='owner_2'
WHERE T1.PROJECT_ID = 0 AND
( T1.REQUEST_TYPE = 'Task'
) AND
(T1.ISSOFTDELETED = 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?
Oct 6 '17 #1
0 2545

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Bill | last post by:
I have a column of digits I'd like to copy into another column in the same table. How would I do this? Thanks, Bill
0
by: Nicholai Yu | last post by:
Hi everyone I know only some about .net and C# but nothing about Windows API and Shells and etc. So if this is not possible please tell me. I want to copy a text from another process (from IE...
10
by: Steve Bostedor | last post by:
Does anyone have an example of how to file.copy as another user? Do I create a new thread as another user? How is that done? Thanks!
1
by: jvorselaars | last post by:
Does anybody how I can copy several fields into the clipboard. I have copied the code of the following microsoft website: http://support.microsoft.com/support/kb/articles/q210/2/13.asp But...
2
by: TonyJ | last post by:
Hello! I use System.IO.File.Copy(exeFileServer,exeFileLocal); and this exeFileServer is located on another computer node in the network I want to catch the error by using try...catch if this...
5
by: krishhhna | last post by:
hi this is krishhhna, plzz tell me how to copy one column data into another column ,the both columns are in the same table..what is the query
4
by: JDVOIGT | last post by:
I am building a P&L on worksheet(1) based on data from worksheet(2). I need to copy rows of data from worksheet(2) and paste onto worksheet(1). The pasting process needs to find a named range (one...
2
by: Deven Oza | last post by:
Hi, Does anyone have an idea that how to copy column(s) from one excel sheet to another sheet using sql server. Thanks for your help in advance. -Deven
1
by: Lila Puri | last post by:
I do have 18000 rows to be copied from Excel to Access. When I do it, it gives error like copy/sharing limit exceed... How can I do it?
1
by: geotex2 | last post by:
Source column, defined as A2:A lives in a worksheet called "PROJECT LIST" and contains a string in each cell. There are 4000+ cells in this column. These need to be copied and pasted into a worksheet...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.