Re: SQL basic problem, apparently...

On 2005-03-23, inferno2000 <inferno2000_at_my-deja.com> wrote:
> "Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<42371fd2$0$31189$626a14ce_at_news.free.fr>...
>> "Jay" <jerome.avoustin_at_insa-lyon.fr> a écrit dans le message de
>> news:349f4455.0503150902.54413cfa_at_posting.google.com...
>> | but what I expect is something like :
>> |
>> | --------------------------------
>> | Firstname LastName Jobs
>> | Jean DUPONT Baker, Barman
>> | Bernard MARTIN Baker, Plumber, Farmer, Webmaster
>> | etc...
>> | --------------------------------
>> |
>> | You'll tell me that it is easy to get whith a GROUP BY ont the person,
>> | but which grouping function can I use to "concat" the Jobs in a
>> | typical sql query ??? Is there a non-"GROUP BY"-based solution ??
>> |
>> | To help you, I don't know the maximum of jobs of a person.
>> |
>> | Thanks to help me :o)
>>
>> This has been asked last week and almost once each week.
>> Can you Google search before asking?
>
> Well, I don't think it is easy to google search and get the right
> answer for question such as this, and unfortunately I am not a
> frequent reader of this group. But just for discussion's sake, I would
> have create a stored function to select and concat the details and
> return this value with a GROUP BY on the primary table. I wonder has
> anyone else gets a different and easier solution.

search for 'user defined aggreagate function +oracle' or similar

hth
Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch/