Home » SQL & PL/SQL » SQL & PL/SQL » Concentrating multiple rows? (Oracle 9)
Concentrating multiple rows? [message #333787] Mon, 14 July 2008 07:54 Go to next message
Merlin123
Messages: 1
Registered: July 2008
Junior Member
Hi!

Maybe there are millions of answers, but I don't know how to find them. Sad

I have two tables:
The first one contains a group name and a link to the person who is responsible for this group
The second table contains the details for this person.

Ok...
I need a statement which gives me the following output:

Name and email address (from the userform) an than a list of all groups for which this person is responsible IN ONE COLUMN.


Should look like this:

tom tom@x.xom eroup1, group2
sam sam@x.com group3, group4, group5
...

How can I do this?

Thanks,
Oliver
Re: Concentrating multiple rows? [message #333789 is a reply to message #333787] Mon, 14 July 2008 07:58 Go to previous message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Seearch for pivot here.
Previous Topic: How to dedicate USER1 for SID_INSTANCE 1
Next Topic: Complex Report using SQL*PLUS
Goto Forum:
  


Current Time: Wed Dec 07 22:23:25 CST 2016

Total time taken to generate the page: 0.08820 seconds