Thread: How can i combine two columns

hi

how can i combine too cols to one.

col1 | col2
-----+-----
1    | 3
2    | 5

select combine(col1,col2) from table; (or whatever the command will be)
should give something like:

combine
-------
1
3
2
5

ville jungman, ulvilantie 3 b 11, 00350 helsinki, finland
tel. + 358 - 9 - 225 4482 , http://www.kolumbus.fi/vilmak
usko Herraan Jeesukseen, niin sin� pelastut. (apt. 16:31)



_________________________________________________________________
Tired of spam? Get advanced junk mail protection with MSN 8.
http://join.msn.com/?page=features/junkmail

On Wed, 12 Feb 2003, Ville Jungman wrote:

> hi
>
> how can i combine too cols to one.
>
> col1 | col2
> -----+-----
> 1    | 3
> 2    | 5
>
> select combine(col1,col2) from table; (or whatever the command will be)
> should give something like:
>
> combine
> -------
> 1
> 3
> 2
> 5
>

    Simple

SELECT col1 as combine from table UNION ALL SELECT col2 from table;

    UNION ALL because Union would remove any duplicates from the new
table. UNION ALL is also quicker than UNION.

Peter Childs.