Re: How can i combine two columns

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.