How to display 1:Many in a single query

I need to return the following data via a single query, if it is possible. I haven't had any luck so far.

Given the classic tables department and employee, list the dept name and all employees in the dept as follows:

Dept Name Employees

--------------  ------------------------------ 
Admin           Joe, Sally, Mark
Programming	John, Jill, Jack, Marie
Mgmt		Rick, Kim, Nick

Is there an easy way to do this with a SINGLE SELECT statement? I'm sure I could do it using PL/SQL but that type of interface won't work in this case.

Thanks for any help!

Lorrie Gagnon
Digital Systems Research
gagnon_at_dsr.com Received on Mon Nov 28 1994 - 19:14:28 CET