Take a look at http://www.sqlmag.com/Articles/Index.cfm?ArticleID=15608.

>hi. my friend posed me this problem. is there a select statement with multiple values returned on a single result set field?
>
>here is a sample of what he meant:
>
>table1
>ID Cust
>--- ----
>11 AAA
>12 BBB
>13 CCC
>
>table2
>ID Prod
>--- ----
>11 MMM
>11 NNN
>12 MMM
>12 NNN
>12 OOO
>13 MMM
>13 OOO
>
>is there a query possible to return this result set?
>
>ID Cust Prod
>--- ---- --------------
>11 AAA MMM, NNN
>12 BBB MMM, NNN, OOO
>13 CCC MMM, OOO
>
>
>if anyone could enlighten me, i would appreciate this very much! thanks in advance!