Home » SQL & PL/SQL » SQL & PL/SQL » Pivot and Crosstab Queries
Pivot and Crosstab Queries [message #257617] Wed, 08 August 2007 15:24 Go to next message
zubamark
Messages: 1
Registered: August 2007
Junior Member
Hello,

I have the view
ID DATE_MX VENDR BPMX OCMX MISC
12 8/12/07 12345 BP50 OC45 NULL
12 8/12/07 12345 NULL NULL BP20
12 8/12/07 12345 NULL NULL BP30
12 8/12/07 12345 NULL NULL OC10

and I need to display 1 row using the view
ID DATE_MX VENDR BPMX OCMX MISC
12 8/12/07 12345 BP50 OC45 BP20,BP30,OC10

Please help!!



Re: Pivot and Crosstab Queries [message #257619 is a reply to message #257617] Wed, 08 August 2007 15:29 Go to previous message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just search for pivot, here or on AskTom or Google or on http://www.sqlsnippets.com
Closed.
./fa/448/0/
Regards
Michel
Previous Topic: Need Help w/ Select Statement to retrieve rows that contain the same values.
Next Topic: Dynamic Variable Names
Goto Forum:
  


Current Time: Fri Dec 09 09:26:42 CST 2016

Total time taken to generate the page: 0.08916 seconds