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

In article <915gj7$gns$1_at_nnrp1.deja.com>,   Mark D Powell <markp7832_at_my-deja.com> wrote:
> In article <914m3o$sf6$1_at_nnrp1.deja.com>,
> jainbi_at_my-deja.com wrote:
> >
> >
> > Hi,
> >
> > My Problem is to find a number in table which have number in its two
> > column, and to find a single column of ordered number from these.
> >
> > rgds,
> >
> If you have described what you want correctly or if I understand what
> you mean correctly this is a simple request. In fact it sounds like a
> school assignment in which case I should not provide the code I
 started
> to post. Instead just write a union (eliminate duplicates) or union
> all (accept duplicates) of a select of column 1 from the table and a
> select of column 2 from the table with an order by clause.
>
> I will leave it to you to look up the syntax.
> --
> Mark D. Powell -- The only advice that counts is the advice that
> you follow so follow your own advice --
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Yes,I am new in databases and trying to pick out some thing, will be great if u send some more links, problem is:
If I have the table of two column ( (10,20,30,40) ,(1,2,3,4) ), how can i view it as a single column (1,2,3,4,10,20,30,40),

regards,

Sent via Deja.com
http://www.deja.com/ Received on Tue Dec 12 2000 - 20:00:05 CET