From: Mark D Powell Newsgroups: comp.databases.theory Subject: Re: Is it possible to merge the column in SQL Queries. Date: Tue, 12 Dec 2000 15:35:03 GMT Organization: Deja.com - Before you buy. Lines: 26 Message-ID: <915gj7$gns$1@nnrp1.deja.com> References: <914m3o$sf6$1@nnrp1.deja.com> NNTP-Posting-Host: 199.228.142.8 X-Article-Creation-Date: Tue Dec 12 15:35:03 2000 GMT X-Http-User-Agent: Mozilla/4.0 (compatible; MSIE 5.5; Windows NT 4.0) X-Http-Proxy: 1.0 x52.deja.com:80 (Squid/1.1.22) for client 199.228.142.8 X-MyDeja-Info: XMYDJUIDmarkp7832 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.