Summarize multiple rows in one value

Hi,

I'm looking for a way to do a group-by query that concatinates text-values into 1 value.

eg.
Original table
REQ_ID ASS_ENG

001            JMA
002            ACT
002            NRP
003            ADL
003            NRP

Desired result
REQ_ID ASS_ENG

001            JMA
002            ACT, NRP
003            ADL, NRP

Any suggestions?

Thanks in advance,
Steven Received on Mon Jun 17 2002 - 12:28:06 CEST