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

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" <markp7832_at_my-deja.com> wrote in message news:915gj7$gns$1_at_nnrp1.deja.com...
> 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.
Received on Tue Dec 12 2000 - 19:38:43 CET