From: jainbi@my-deja.com
Newsgroups: comp.databases.theory
Subject: Re: Is it possible to merge the column in SQL Queries.
Date: Tue, 12 Dec 2000 19:00:05 GMT
Organization: Deja.com
Lines: 44
Message-ID: <915sjg$s9h$1@nnrp1.deja.com>
References: <914m3o$sf6$1@nnrp1.deja.com> <915gj7$gns$1@nnrp1.deja.com>
NNTP-Posting-Host: 216.6.88.34
X-Article-Creation-Date: Tue Dec 12 19:00:05 2000 GMT
X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)
X-Http-Proxy: 1.1 HSSCACHE (NetCache 4.1R5), 1.0 x59.deja.com:80 (Squid/1.1.22) for client 139.85.243.161, 216.6.88.34
X-MyDeja-Info: XMYDJUIDjainbi


In article <915gj7$gns$1@nnrp1.deja.com>,
  Mark D Powell <markp7832@my-deja.com> wrote:
> In article <914m3o$sf6$1@nnrp1.deja.com>,
>   jainbi@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/