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

>>>>> "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),

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/