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

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.