help! i need a solution pleas..cn i use subquery..

[ramorac]

hi my requirement is something like this..

say.. there are two columns
A and B.
In B there are values b1 b2 b3 b4.....

the output should be..
---------------------
Column_Name
----------------------
A
b1
b2
b3
b4..and so on..

Basically i should gt the values of B(b1 b2 b3 b4..) under A in d same column..Pleas help me..very urgent..

[amitpatel66]

Ramorac,

Welcome to TSDN!!

I insist you to go through the Posting Guidelines of this forum which will help you understand the DO and DONT's of this forum. The use of SMS abbreviations are not allowed while posting in this forum. And there are many other guidelines as well. Make sure you go through the guidelines and adhere to it.

Thanks
MODERATOR

[amitpatel66]

Try this:

[code=oracle]

SELECT A from Table1
UNION ALL
SELECT B from Tabl1

[/code]

[ramorac]

thank you amit!
i will adhere to the rules of this forum.

[amitpatel66]

thank you amit!
i will adhere to the rules of this forum.

I really appreciate that!!