Re: Is it possible to merge the column in SQL Queries.

I think UNION wont work to his question. His question is of pivoting 2 columns into one and there is no easy SQL solution to it AFAIK. -Aakash

Arto Viitanen wrote:

> >>>>> "jainbi" == jainbi <jainbi_at_my-deja.com> writes:
> jainbi> Yes,I am new in databases and trying to pick out some thing, will be
> jainbi> great if u send some more links, problem is: If I have the table of
> jainbi> two column ( (10,20,30,40) ,(1,2,3,4) ), how can i view it as a
> jainbi> single column (1,2,3,4,10,20,30,40),
>
> How about:
>
> select first
> from table
>
> union
>
> select second
> from table
>
> ?
>
> --
> Arto V. Viitanen av_at_cs.uta.fi
> University of Tampere, Department of Computer and Information Sciences
> Tampere, Finland http://www.cs.uta.fi/~av/
  Received on Fri Dec 22 2000 - 00:32:44 CET