How to concatenate two outputs in DB2 database?

A_SUSHMA · Post by **A_SUSHMA** » Fri May 16, 2014 3:30 am

Hi All,

How to concatenate the two query data output

Example column1 as 1st query output,column2 is second query output.

column1
-----------
1000
2000
3000

column2
--------
1111
2222
3333
I want to concatenate two query outputs in DB2 database..
Please help me the same.

ray.wurlod · Post by **ray.wurlod** » Fri May 16, 2014 5:10 am

What exactly do you want? A union, row-by-row concatenation, cross join, something else?

ArndW · Post by **ArndW** » Fri May 16, 2014 5:10 am

What do you mean by concatenate in this case? What would your output look like for input column A and B with values 1000 and 1111?