Advanced SELECT

Hi Folks,

I hope to have found the right group for my question. I have difficult
sql-task. I try to describe it simple:

We have a table 'company' with a cid and a table 'sector' with a sid.
They are connected m:n via a third table 'company_sector' which contians
csid, cid and sid.

The normal clause would look like:

SELECT c.companyname, s.sectorname FROM company c, sector s,
company_sector cs WHERE cs.cid = c.cid AND cs.sid = s.sid ORDER BY
c.companyname;

This gives a result looking like this:

c.companyname | s.sector
---------------+------------------------
company1 | sectora
company1 | sectorb
company2 | sectora
company2 | sectorb
company2 | sectorc
company3 | sectora
company4 | sectorc

instead of this I want to have a listing like:

c.companyname | ??? (sectors)
---------------+------------------------
company1 | sectora, sectorb
company2 | sectora, sectorb, sectorc
company3 | sectora
company4 | sectorc

But I have no idea, how to write a SELECT-command that gives a listing
like this :( Maybe anyone can help *please*

*Thanks and greetings*
Kai...

--
GnuPG-PublicKey -> http://www.hobsons.de/pgp/kai_hessing.asc

Unzeitige Genuesse erzeugen Ekel.
(Demokrit, um 460 v. Chr.)