Home » SQL & PL/SQL » SQL & PL/SQL » Displaying unrelated columns
Displaying unrelated columns [message #1216] Thu, 11 April 2002 11:54 Go to next message
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.

Report message to a moderator

Re: Displaying unrelated columns [message #1217 is a reply to message #1216] Thu, 11 April 2002 11:59 Go to previous message
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

Report message to a moderator

Previous Topic: indexing
Next Topic: I/O
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Nov 04 00:21:24 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.