Home » SQL & PL/SQL » SQL & PL/SQL » SQL query Problem
SQL query Problem [message #251815] Mon, 16 July 2007 14:56 Go to next message
Messages: 6
Registered: June 2007
Junior Member
I have one field called CODE and another one called TYPE.
there are two types of values for TYPE. 'A' and 'B'

What i want to do is return the CODE to one column when the TYPE = A and return the CODE to the other column when the TYPE = B

so my results should look like this:

012 ------
213 ------
Re: SQL query Problem [message #251822 is a reply to message #251815] Mon, 16 July 2007 16:05 Go to previous messageGo to next message
Messages: 24963
Registered: January 2009
Location: SoCal
Senior Member
Please read & FOLLOW the posting guidelines as specified in the STICK posts at teh top of this forum.
Re: SQL query Problem [message #251873 is a reply to message #251815] Tue, 17 July 2007 01:07 Go to previous message
Michel Cadot
Messages: 63924
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And once more a basic "pivot" (search for this word) query.
Topic closed
Previous Topic: Character Set in Oracle
Next Topic: QUOTA: Oops
Goto Forum:

Current Time: Wed Oct 26 07:00:14 CDT 2016

Total time taken to generate the page: 0.05669 seconds