Displaying unrelated columns [message #1216] |
Thu, 11 April 2002 11:54 |
Bluefish
Messages: 3 Registered: April 2002
|
Junior Member |
|
|
I would like to display two different set of columns , the two sets are not related to each other in the same resultset.
For example: Table1 has col1, col2....col10
I would like to display col1, col3, col4 based on condition CONDITION1 and col1, col3, col4 based on condition CONDITION2 all in the same select statement.i.e; the resultset should display as :
col1 col3 col4 col1 col3 col4. (The first three being from a different coondition than the last three).
I hope I have explained this well enough.
Is there any way I can do this in oracle?
Thanks.
|
|
|
Re: Displaying unrelated columns [message #1217 is a reply to message #1216] |
Thu, 11 April 2002 11:59 |
Bluefish
Messages: 3 Registered: April 2002
|
Junior Member |
|
|
The results should be similar to a union but in this case I should be able to do a Vertical Union instead of Horizontal. The two sets of columns should display BESIDE each other.
Please help.
thanks
|
|
|