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

Sorry read the question wrongly! Union is the correct solution. -Aakash

Philip Lijnzaad wrote:

> On Thu, 21 Dec 2000 15:32:44 -0800,
> "Arto" == Aakash Bordia <a_bordia_at_hotmail.com> wrote:
>
> Arto> I think UNION wont work to his question. His question is of pivoting 2
> Arto> columns into one
>
> what do you mean by pivoting? To me it looks like UNION is exactly what's
> needed.
> Philip
>
> 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
> >>
>
> --
> C++: The power, elegance and simplicity of a hand grenade. (Kenneth C. Dyke)
> -----------------------------------------------------------------------------
> Philip Lijnzaad, lijnzaad_at_ebi.ac.uk \ European Bioinformatics Institute,rm A2-08
> +44 (0)1223 49 4639 / Wellcome Trust Genome Campus, Hinxton
> +44 (0)1223 49 4468 (fax) \ Cambridgeshire CB10 1SD, GREAT BRITAIN
> PGP fingerprint: E1 03 BF 80 94 61 B6 FC 50 3D 1F 64 40 75 FB 53
  Received on Fri Jan 05 2001 - 02:07:59 CET