Query Question

I have a table defined like:

CREATE TABLE ORGS
(

NUM	INTEGER	NOT NULL,
ID	INTEGER	NOT NULL

In the table I have like:

num id

41     5
41     6
41     7
99     5
89     9

I was wondering if there is a method where I can generate a result dataset from a sql query that looks like:

41 5,6,7
99 5
89 9

My approach currently is to iterate over the result dataset to produce this.

Mike Received on Fri Mar 11 2005 - 10:06:13 CST