Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL basic problem, apparently...

Re: SQL basic problem, apparently...

From: inferno2000 <inferno2000_at_my-deja.com>
Date: 23 Mar 2005 01:33:34 -0800
Message-ID: <a9390719.0503230133.5958f058@posting.google.com>


"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. Received on Wed Mar 23 2005 - 03:33:34 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US