Re: SQL basic problem, apparently...

Jay wrote:

> Hi !
>
> Here it is :
> Imagine this situation :
> I've got 3 tables. A person can have several jobs (imagine... ;o). *
> means primary key
> PERSON : IdPers*, FirstName, LastName
> WORK : IdPers*, IdJob*
> JOB : IdJob*, JobLabel
>
> If I request my database to have all the jobs of everybody, I get that
> :
>
> --------------------------------
> Firstname LastName JobLabel
> Jean DUPONT Baker
> Jean DUPONT Barman
> Bernard MARTIN Baker
> Bernard MARTIN Plumber
> Bernard MARTIN Farmer
> Bernard MARTIN Webmaster
> etc...
> --------------------------------
>
> This is very easy.
> 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 homework requires PL/SQL not SQL: Think stored procedure.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)