From: "Alan" Newsgroups: comp.databases.theory Subject: Re: Is it possible to merge the column in SQL Queries. Date: Tue, 12 Dec 2000 13:38:43 -0500 Lines: 34 Message-ID: <915rar$80p$1@bob.news.rcn.net> References: <914m3o$sf6$1@nnrp1.deja.com> <915gj7$gns$1@nnrp1.deja.com> X-Trace: 3u2D7LroLyonw6UiuFgFQiXglfxcjvMSeylQ9p5JOyBVKPlTlUf5og== X-Complaints-To: abuse@rcn.com NNTP-Posting-Date: 12 Dec 2000 18:38:19 GMT X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MSMail-Priority: Normal X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 There are always a lot of school assignments in the newsgroups this time of year (fianls, etc.). They're usually pretty easy to spot. "Mark D Powell" wrote in message news:915gj7$gns$1@nnrp1.deja.com... > 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.